Need help Comparing Dates

[gjmac2]

Please forgive my ignorance, but my knowledge of SQL and VBA is very limited.

I have a table with a field entitled LAST MODIFIED.

The table is comprised of both a date and a time value.

I frequently import new data into this table, with changes to the individual records, which is reflected in the LAST MODIFIED field.

My question is this....How do I query this table to return the record with the most current date and/or time in the LAST MODIFIED field?

Here is an example of one of the entries...


02/01/2006 12:42:25 AM

Thank you.

 

[lespaul]

select MAX([Last Modified]) FROM TableName

should give you the latest entry

Leslie

Anything worth doing is a lot more difficult than it's worth - Unknown Induhvidual

Essential reading for anyone working with databases: The Fundamentals of Relational Database Design

 

[gjmac2]

Thank you for the rapid response.

Again, please excuse my ignorance, but should the statement you posted be put in the criteria field of design view, or in the sql view?

 

[lespaul]

in the SQL view and you'll need to fix TableName to the correct name.

Leslie

Anything worth doing is a lot more difficult than it's worth - Unknown Induhvidual

Essential reading for anyone working with databases: The Fundamentals of Relational Database Design