access query show first date last date

[Guest]

I have a query that lists the results for bills sent out during a specific
time period. The query returns all vendors that have been billed. Some
vendors have more than one bill. I would like to show the first billing date
and the last billing date and include the total bills sent and the total of
payments received. I have no idea how to set this up. Any help would be
appreciated. Thanks.

 

[Lynn Trapp]

Give the following query a try:

SELECT VendorName, Min(BillingDate),
Max(BillingDate),Count(Bills),Sum(PaymentsReceived)
From YourTable
Group By VendorName;

Obviously, I don't know your field names, so you will need to supply the
appropriate names in the place of my guesses here.

 

[Guest]

Thank you!

Give the following query a try:

SELECT VendorName, Min(BillingDate),
Max(BillingDate),Count(Bills),Sum(PaymentsReceived)
From YourTable
Group By VendorName;

Obviously, I don't know your field names, so you will need to supply the
appropriate names in the place of my guesses here.

--

Lynn Trapp
Microsoft MVP (Access)
www.ltcomputerdesigns.com

 

[Lynn Trapp]

You are very welcome.