Blank Records Retrieved on Query

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a query that works fine except that a blank record appears at the end
of the retrieved records. This blank record also appears on the form on which
uses the query as it's record source.

How can I stop the blank record appearing in the query and/or on the form?
 
Hi Rillo,

You have two options here, one of which was described by Svetlana, the
other is to set the Recordset Type in the query to Snapshot.

Good luck

Nick
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

#error - Blank 3
Query criteria - exclude data and return all records if null 3
query to pull between two dates 4
How does one eliminate blank records on a query result? 3
Delete records based on two sets of criteria 14
Query to show all if parameter is blank 2
Parameter query where blank is like "*" 2
Form is blank 5

Back
Top