give me the latest date

[cliff7376]

I have a query i want to run on a table. I have a table that stores time worked on a certain operation of a work order. What I want to do is have my query give me the last operation that job was at by getting the latest time . How do I have my query give me only the record of that job where the time is the greatest.

 

[adz2013]

In the design view on the tool bar there is a button for TOTALS. Click on that and then above sort there is a totals field select Max.

 

[cliff7376]

all that seems to do is put them in order am i doing something wrong? I click on the total button and then i click on max. I tried last but that didn't work either. Please help

 

[cliff7376]

Pat i'm very sorry i was replying to the first answer. It worked great once I applied what the first person said to what you said. Thanks alot guys you are all a great help.