Home > IT Answers > Database > How do I retrieve the most recent date from an access database
TheMooseRI
15 pts.
 How do I retrieve the most recent date from an access database
Access 2003, Access Database, Microsoft Access
I am building a report in Access 2003 and am trying to pull data based on the most recent service call for a customer. There is typically several service call dates for each customer, but the only record I am concerned with is the most recent date.

Software/Hardware used:
ASKED: August 15, 2008  5:29 PM
UPDATED: August 18, 2008  2:28 PM
RELATED QUESTIONS
Answer Wiki:
You probably need to write a SQL query to do this. Try something like this: select * from service_call where customer_id = form.customer_id and call_date = (select max(call_date) from service_call where customer_id = form.customer_id);
Last Wiki Answer Submitted:  August 18, 2008  2:28 pm  by  Dwaltr   900 pts.
All Answer Wiki Contributors:  Dwaltr   900 pts.
To see all answers submitted to the Answer Wiki: View Answer History.


RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _

 

You can do it with accdb repair tool

steviekoks
 10 pts.
 

The Access repair tool is no help for this question at all. — Tom

TomLiotta
 107,735 pts.
 

Make sure the date is stored in a true Date data-type field for this to work.

Mlwonio
 90 pts.