Query

  • Thread starter Thread starter Pass-the-reality
  • Start date Start date
P

Pass-the-reality

On my Query I have CallLogID and ReviseDate. ReviseDate includes the date
and time the record was last revised. When I run my query, there could be
several rows for the same CallLogID, as the ReviseDate is different (see
below). How do I tell my query to only show one row per CallLogID and that
the row to show should be the one with the max ReviseDate.


Call Log ID ReviseDate
347223 2/6/2009 9:11:36AM
347223 2/6/2009 9:20:00 AM
347224 2/6/2009 10:20:00 AM
 
Open the query you are using in design view.

Click on the Totals button (sideways "M", the 'sigma' character).

Use "GroupBy" for [CallLogID].

Use "Maximum" for [ReviseDate].

Run it

Regards

Jeff Boyce
Microsoft Office/Access MVP
 

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

Similar Threads

Need help with syntax 0
Report with information cross the page 1
Combining records by date 1
date & time question 7
concatenation of multiple rows into a single row 2
Query or report 5
How do I find a match for three variables to determine the result? 4
TYPE CONVERSION 1

Back
Top