Blank row when I execute a query

[QuietRiot]

why do I get the new record (blank row) at the bottom of a query? Hopefully I can explain this well. When you run a query the last row should just contain the last result. In my case when I run it the last row contains the asteric and a blank row to add. This causes the Invalid use of Null error when I try to use it in another query. Any ideas?

SELECT trim(ITAimport.F5) AS Fund, trim(ITAimport.F1) AS AccountNumber, cdbl(trim(ITAimport.F4)) AS TotalPhysicalShares, trim(ITAimport.F5) & trim(ITAimport.F1) & cdbl(trim(ITAimport.F3)) AS UniqueId
FROM ITAimport
WHERE ITAimport.F1 IS Not Null And ITAimport.F1 Not Like "Account*";

 

[pbaldy]

In the properties of the query, try changing the Recordset Type to Snapshot.

 

[QuietRiot]

In the properties of the query, try changing the Recordset Type to Snapshot.

That was it. Thank you!!