Query Based on Date and Item

[Jtrim52]

I am trying to track railcar activity. I have daily entries by railcar number and date. I want to list only the lastest date for each railcar. For example I have 102 cars to track. There are 900 entries, and I just want to list one record per car that shows the last date for that car.

 

[Eupher]

Hi, Jtrim52,

Have a look at the DMax function. Or in your query you may use the Top keyword.

Ken S.

 

[TheAceMan1]

How are ya Jtrim52 . . .

You need a [blue]Totals[/blue] query, the SQL of which is something like:

[blue]SELECT Count(ID) AS CntID, RailCarNum, Max(RailDate) AS MaxDate
FROM tblRailcars
GROUP BY RailCarNum;[/blue]

See Ya! . . . . . .