query resultes include blank record

[Lin Light]

I have just noticed on a query that a blank record comes along with my results.
I have run other queries but none have a blank record in with the results.

Lin

 

[Maurice]

It depends on how your query is set up. I assume you have more than one
table in your query. When creating an Inner Join you won't see the blank
record. You probably set your main table to be right or left joined. In
designview of the query look at the join (the line between the tables). The
join should not have arrows either way if you just want records that have
matching records in the matching table. If you do have an arrow in the join
than that's what is causing the blank record. You can change this (if needed)
by rightclicking on the join and choose option 1.

hth

 

[Tom van Stiphout]

On Fri, 29 Aug 2008 06:16:01 -0700, Lin Light

Open the underlying table and sort it. You'll find the record. Delete
it, or fill in the missing values. Then set those fields to be
required.

-Tom.
Microsoft Access MVP