R
Rick Bortness
I am currently writing an aging report and now find it necessary to eliminate
line items that are returned for credit on the report listing. The report is
as follows:
Date Invoice# Tax Freight Sales Return Status
-------------------------------------------------------------------------
5/01/2005 11714011 20.00 26.25 1631.35
5/02/2005 11713022 0.00 0.00 (600.00) Return from 11713024
5/04/2005 11713024 25.00 34.75 2400.00
When I am performing a lookup on the return status field by the commented
substring 11713024, I want to use that value to lookup that invoice number in
the invoice field. If it does not exist, then I don't want to print the line
for that invoice.
Any suggestions on my query criteria?
line items that are returned for credit on the report listing. The report is
as follows:
Date Invoice# Tax Freight Sales Return Status
-------------------------------------------------------------------------
5/01/2005 11714011 20.00 26.25 1631.35
5/02/2005 11713022 0.00 0.00 (600.00) Return from 11713024
5/04/2005 11713024 25.00 34.75 2400.00
When I am performing a lookup on the return status field by the commented
substring 11713024, I want to use that value to lookup that invoice number in
the invoice field. If it does not exist, then I don't want to print the line
for that invoice.
Any suggestions on my query criteria?