Novice really needs some help

[Hunter J.]

I have attached a zip of a test data base. I am trying to get the last date and time associated with Tagindex 19, 38, 22 and 29
8/30/2004 09:27:59 19
8/30/2004 09:28:29 38
8/30/2004 09:28:59 22
8/30/2004 10:39:04 29

Any help is welcome
Hunter J.

 

[Jon K]

I have added two queries in your database. You can run the second query.

Note
I have changed the [Time] field from Text to Date/Time data type.
.

 

[Hunter J.]

Thanks Jon K.

The query still returns the same time for all four TagIndex. Thanks for the help.

Hunter J.

 

[Jon K]

In your database, 30/8/2004 10:39:04 AM happens to be the most recent date time of each of the TagIndexes 19, 38, 22 and 29.

If you add 4 records of later dates and times for these 4 TagIndexes, the queries should be able to return them.
.