Dates

[drock99a]

I have a table that has a date completed field. I need my query to look at this field and tells me that last time that particular item was worked on. The query shows the original date and not anything newer. For example PC #1 was originally worked on 11/1/04, it was again serviced on 12/15/04 the query keeps referring back to 11/1/04, I need it to show the most recent time it was worked.

 

[Norie]

What query do you currently have?

Can you not use a totals query and Max for the completed field?

 

[drock99a]

SELECT DISTINCTROW TOP 5 Completed.*, Completed.User, Completed.Location, Completed.[Printer Name], Completed.[Printer Type], Completed.[Serial Number], Completed.Zone
FROM Completed
WHERE (((Completed.Zone)=[Zone :]))
ORDER BY Completed.[Date Completed];