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 :)
We live in a world of interfaces like the one in the title picture. VBA also allows to use interfaces which offers a lot of possibilities. This article describes how to use interfaces in VBA and how to work around their bugs.
How can you see what you are working on when you want to see it while you to save a copy?
Add a "Save As" icon to the Quick Access Toolbar, or QAT.
That way, when you save a copy of a query, form, report, or other object you are modifying, you…
Get the source code for a fully functional Access application shell with several popular security features that Access VBA application developers desire, but find difficult or impossible to figure out how to code.
You get the source code for managi…