the 1st transaction

F

fishqqq

I need to create a query which will show me the date of the first
transaction we did with different vendors.

for example we may have 1000 transactions with a certain vendor but i
need the query to only show me the date of the 1st transaction.
The fields i suspect i'll need are the [vendor_name] &
[transaction_date]

Can someone show me how to set this up in a query?

your suggestions are greatly appreciated.
- Steve
 
J

Jeff Boyce

Steve

Open a new query in design mode.

Add the Transaction table (or whatever you've called it).

Double-click on the VendorName field to add it to the "grid".

Double-click the TransactionDate field to add it to the "grid".

Click the Toolbar button that represents the "Totals" query (a "sigma" -
looks like a backwards 3)

Leave the value "GroupBy" under the VendorName in the "Total:" row.

Change the value to "Minimum" for the "Total:" row under TransactionDate.

Run it.

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
Top