Blank Row in Query

  • Thread starter Thread starter Lamar
  • Start date Start date
L

Lamar

I am creating queriess based on linked tables. When I run
some queries a blank row appears even if no data is
returned. I run other queries and no blank row appears
when there is no data. Does this have something to do with
linked tables? I cannot change the linked tables.

I want the blank rows to appear because I am using the
queries as a record source for forms. As you may know if
a form is based on query with no value then the form does
not appear. This is my problem.

Is there a way to ensure that a query will at least have a
blank row even if no data is returned when the query is
run? Thanks for any help.
 
I suspect that the queries that aren't returning the blank rows aren't
updatable. If they're simple queries against a single table, you probably
haven't got a primary key defined for the table. If they're more complex
queries, you may have to work with them to ensure they're updatable.
 
Back
Top