I'm trying to build a parts pricelist in QRY, using MBBZREP/BZANVA (item base 
price) as the price to be printed.

Query kinda works but I'm getting a line printed for each part # for every time 
the part price was changed.

Is there any way to only print the current part price or am I looking the wrong 
file/field?

TIA

Jim



As an Amazon Associate we earn from qualifying purchases.

This thread ...


Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2021 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.