Pick the Latest transaction date for a multiple Items DBase

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I need help to build a query to pick only the latest transaction date from a multiple transaction date with multiple Items Data Base? The idea is to have only the latest date of an especific transaction type X per item.

I tried the Top Value but the query came with more than one date for one Item. The Query format was designed using two tables: The Item Master List (Only SKU# with not duplicated SKU’s and the Transaction History with the Transaction Type: XX, Transaction Date (Sort in descending date to have the latest date first) and the SKU#.

(e-mail address removed)
 
See:
Queries: Getting a related field from a GroupBy (total) query
at:
http://www.mvps.org/access/queries/qry0020.htm

The article explains 4 ways to achieve this. The subquery might be best.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.

Reply to group, rather than allenbrowne at mvps dot org.

Thomas Moreu said:
I need help to build a query to pick only the latest transaction date from
Click to expand...
a multiple transaction date with multiple Items Data Base? The idea is to
have only the latest date of an especific transaction type X per item.
I tried the Top Value but the query came with more than one date for one
Click to expand...
Item. The Query format was designed using two tables: The Item Master
List (Only SKU# with not duplicated SKU's and the Transaction History with
the Transaction Type: XX, Transaction Date (Sort in descending date to
have the latest date first) and the SKU#.
 
Back
Top