Lowell has hit the nail on the head!

If you repair and compact the First() function it now returns A rather than B.

However this is only if the table has a...

Matt,

The help excerpt you published references a DAO recordset object. I am not using a recordset in my example - i am simply creating a query against a table.

Thanks anyway...

Sorry but i do not agree with you.

MS Access holds an internal bookmark on records in tables so it can determine the first record entered into that table. (I cannot...

The First() function in MSAccess returns the first record entered into the table.

SELECT TOP 1 is not the equivalent.

Try creating a new table in MSAccess with one string field. Enter...

The First() function in MSAccess returns the first record entered into the table.

SELECT TOP 1 is not the equivalent.

Try creating a new table in MSAccess with one string field....

Im pretty sure it's cause you haven't got any brackets () around your join criteria.

Suggest you go into Access and create a query with the query designer that has a...