query

  • Thread starter alxw3 via AccessMonster.com
  • Start date
A

alxw3 via AccessMonster.com

acces 2003:
date3 > date2 > date1 ...
table A has item, item1, item2,...
tableA:
item date1
item date1
 
A

alxw3 via AccessMonster.com

well tableA has two columns. "Item" and "Date".

An Item may occur number of times during different dates. Need the number of
occurrences of an Item over the latest date. How about using Dolookup and
DMAX("Date" ,.. ..???
 
D

Duane Hookom

"number of times" suggests counting in a totals query. "over the latest date"
suggests only a single record and date per item. A guess is:
SELECT Item, Max([Date]) As RecentDate
FROM TableA
GROUP BY Item;

If this isn't what you want, please type in about 10 records and the desired
output.
 
A

alxw3 via AccessMonster.com

tableA like:
item date1
item date1
item date2
item date2
item date2
item1 date1
item2 date1
item2 date2
item2 date2
 
D

duanehookom

tableA like:
item    date1
item    date1
item    date2
item    date2
item    date2
item1  date1
item2  date1
item2  date2
item2  date2
Click to expand...

I can't believe you expect this to make anything clearer. Is that your
actual data? Did you miss my request for "and the desired output"?
 
Top