Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

advanced micorosoft access training - query criteria

Forum home » Delegate support and help forum » Microsoft Access Training and help » advanced micorosoft access training - Query Criteria

advanced micorosoft access training - Query Criteria

ResolvedVersion Standard

Deborah has attended:
Access Intermediate course

Query Criteria

How do you run a query to select the most recent date added?

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.

Access tip:

How To Display An '&' In A Label In A Form

To have your label display a sentence with an &(ampersand) in it, like Fox & Hound simply type it as:

Fox && Hound

View all Access hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.11 secs.