dates in queries

D

Debbie S.

Hi,
I have a database with titles of articles and a log form. The titles and the
log form are in two different but related tables. The log form has four
fields: title, action, taken by, and date. The purpose of the log form is to
keep track of who is doing what to the article. I want to create a query that
will show the title of the article (this part is easy) along with the LAST
date in the log form for each individual article. The dates are irregular,
meaning actions are taken at all different times, so I can't put < or > or =
because there is no particular date to pinpoint. How do I tell access to pick
the latest date in the log form for each article title?
Thank you,
Debbie
 
M

Marshall Barton

Debbie said:
I have a database with titles of articles and a log form. The titles and the
log form are in two different but related tables. The log form has four
fields: title, action, taken by, and date. The purpose of the log form is to
keep track of who is doing what to the article. I want to create a query that
will show the title of the article (this part is easy) along with the LAST
date in the log form for each individual article. The dates are irregular,
meaning actions are taken at all different times, so I can't put < or > or =
because there is no particular date to pinpoint. How do I tell access to pick
the latest date in the log form for each article title?
Click to expand...


Use a subquery. This article provides details.
http://allenbrowne.com/subquery-01.html#TopN
 
B

bhicks11 via AccessMonster.com

Use the MAX function. Click the Sigma to make it a grouping query, set the
total row to MAX. You can make the other rows group by or expression if you
need.

Bonnie
http://www.dataplus-svc.com
 
Top