98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View Reviews
Forum home » Delegate support and help forum » Microsoft Access Training and help » advanced micorosoft access training - Query Criteria
advanced micorosoft access training - Query Criteria
Resolved · Low Priority · Version Standard
Thu 20 Sep 2007, 16:50Delegate Deborah said...
Deborah has attended:
Access Intermediate course
Query Criteria
How do you run a query to select the most recent date added?
Fri 21 Sep 2007, 15:07Trainer Richard said...
RE: Query Criteria
To select the most recent record use the LAST function
=Last(expr)
Where "expr" is the field you want to look in.
It would find the most recently entered record.
Training information:
See also:
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Access tip:Prefixed AutonumberingWhen using Date Type = Autonumber as a primary key, clients may require autonumbering to be prefixed with a letter. |
