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?


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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top