access query show first date last date

S

SLP

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.
 
L

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.
 
S

SLP

Thank you!

Lynn Trapp said:
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
Click to expand...
 
Top