P
Phil Smith
I have a union query in two pieces. One piece deals with payments by
cash and checks, one deals with payments by credit card and wire
transfer, all per invoice.
There does come situations where a single invoice will be payed
partially in each category, with DateReceived and a few other details
being different for each record. In this case, I get multiple entries
for each invoice, which is a NO-NO.
I want the record which has the latest DateReceived, and all of it's
attendant info.
I can do it by running a totals query on my union query with
MAX(DateReceived), then another query that looks for the record in my
union query matching that invoice and that MAX(DateReceived,) but that
means I am effectively running 4 queries to get my information.
Is there an easier way to get that final result?
Phil
cash and checks, one deals with payments by credit card and wire
transfer, all per invoice.
There does come situations where a single invoice will be payed
partially in each category, with DateReceived and a few other details
being different for each record. In this case, I get multiple entries
for each invoice, which is a NO-NO.
I want the record which has the latest DateReceived, and all of it's
attendant info.
I can do it by running a totals query on my union query with
MAX(DateReceived), then another query that looks for the record in my
union query matching that invoice and that MAX(DateReceived,) but that
means I am effectively running 4 queries to get my information.
Is there an easier way to get that final result?
Phil