I have a table containing every invoice issued to a customer. There are multiple records for each customer's business.
What I'm trying to produce is a query that will return a table containing only the most recent invoice record for each customer so I can follow-up customers who we've had no business with for more than 6 months.
The table has multiple fields but can you suggest a solution using the fields [Customer Ref#] and [Invoice_Date]? I want to pull the whole record for their last business.
Normally I have no problem writing queries but this one has me stumped - I'm blaming it on a head cold :)
Thanks M :o)