Querry help, sorry

[vicsalt]

Before you all shot at me I seem unable to post int the correct sectiction

My simple problem, I want to run a qery to select the last record in a table

ie i have a qery created from 3 tables
The qery gets the last record entered from a specific table

the specific table does have a date and time stamp

 

[namliam]

Select max(datetimestamp) from yourtable

??? That what your looking for ???

 

[vicsalt]

Select max(datetimestamp) from yourtable

??? That what your looking for ???

Sorry where do i put this in the criteria field on the date field

 

[Rabbie]

NamliaM has given you the SQL for your query. Just substitute the actual field name and table name.