Using MS Access/Min Date - Count of Invoices
Good afternoon -
I have a list of 60,000+ orders which are processed on multiple shipment ID's (BOLs). I have a table showing the shipment information and a table showing the order information (creation/received dates).
I am trying to show the first receipt date (min) and the number of orders on that date. I also am trying to pull the total number of orders. I am able to get one or the other, but not both.
-- Any help is greatly appreciated.
Might help to know the table structure.
The main question is where do you want to display this information. But I can see three expressions that will get all three numbers:
2) DCount("*","ordertablename","[OrderDate] = #" & DMin("[shipdate]","shipmenttablename") & "#")
Hope this helps,
Microsoft Access MVP 2007
Author: Microsoft Office Access 2007 VBA