If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
dates in queries
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 |
#2
|
|||
|
|||
dates in queries
Debbie S. wrote:
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 -- Marsh MVP [MS Access] |
#3
|
|||
|
|||
dates in queries
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 Debbie S. wrote: 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 -- Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/For...eries/200807/1 |
Thread Tools | |
Display Modes | |
|
|