Finding the oldest date.

[Dana5535]

I have a access database for bills and customers. I need a query that will give me the oldest bill for each customer. Not sure where to even start.
I have a table for Customers and a table for bills. They are "linked" by the customer number. I found help that allowed me to find the oldest of all the bills but not the oldest for each customer. At this time I have approximately 800 customers and 1,600 bills.

Any suggestions? Please keep it kind of simple, a relative newbie to Access.

Thanks,

 

[Joe4]

Hello again!

This is actually pretty simple to do in Access, with an Aggregate (Totals) Query.
Just create a new query, and add just your Customer field and bill date field to the Query.
Then click on the Totals button (looks like a Sigma).
This will add a new row under each field named "Totals" with the words "Group By" under each of your two fields.
Under the bill date field, change "Group By" to "Min".
Now view the results. This should give you what you want.

Literally, you are "Grouping" all the data on the Customer field and taking the "minimum" value of the bill date field for each "group".

 

[healey21]

In a query select your tables and hopefully you will see the relationships between the tables.
Next use the Autosum Icon which will Group by and make sure company is grouped and the invoices select Last from the drop down in the Group this will give you what you want.