My computer was recently upgraded to Access 2007. The one feature I
can't seem to find in this newer version is how to view the creation
date and last modified date for my queries. I want to sort by that
field, but cannot figure out how to do this. Thanks.

Coll wrote:
Try this code. See if gets you partway there.
Sub q()
Dim q As QueryDef

For Each q In CurrentDb.QueryDefs
If left(q.Name, 1) <> "~" Then
Debug.Print q.Name & " created " & q.DateCreated & _
" modified " & q.LastUpdated
End If
Next
End Sub

You can write functions by modifying the above to pass the query name
and return the dates if the query names are stored in a table a table.