QBE grid display for no results returned

[DayTripper]

I am a newbie just getting used to Access.
I can't see any similar posts on this group, so this is probably a really
dumb question.


I have a query which I am not sure is working properly.

The QBE grid displays the column headers only on returning the query results.
Other queries I have built which find no results show the column headers as
well as a blank row of cells as a return.

I am wondering if I have a problem with my criteria, or if in fact there are
no results to display?

Help really appreciated

 

[Douglas J. Steele]

The blank row of cells is where you'd add new data to the query. If you're
not seeing it, then your query isn't updatable.

 

[Douglas J. Steele]

The blank row of cells is where you'd add new data to the query. If you're
not seeing it, then your query isn't updatable.

 

[John Spencer]

If the query result is updatable then the query will show a blank row
for data entry even if no row has been returned that has data.

If the query result is not updateable, then the blank row will not be there.

'====================================================
John Spencer
Access MVP 2002-2005, 2007-2009
The Hilltop Institute
University of Maryland Baltimore County
'====================================================

 

[John Spencer]

If the query result is updatable then the query will show a blank row
for data entry even if no row has been returned that has data.

If the query result is not updateable, then the blank row will not be there.

'====================================================
John Spencer
Access MVP 2002-2005, 2007-2009
The Hilltop Institute
University of Maryland Baltimore County
'====================================================