Supplier Parts with Price Breaks

[Mark_Wonsil]

We did a BAQ for the current price break, but you may be able to tweak it to do what you need:

BAQ Assistance Requested - I don't know how Joins work

So, to get the most current VendPart takes a subquery and a trick. This is baptism by fire my friend. Create a new innersubquery and drag VendPart to the screen. Create a criteria to eliminate any future EffectiveDates. [image] In your Display Fields, add Company, PartNum, EffectiveDate, and VendorNum. Create a new calculated field called RowNum: [image] What this does is assigns the ROW_NUMBER to each record within the part in descending order (most recent to oldest). I did this is in a…

VendPBrk is the table and there is only an EffectiveDate. Dumping that table to Excel might be good enough, or you can play with the BAQ to do a COUNT on the number of records to find multiple records for the supplier/part combo.