QBE grid display for no results returned

D

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
 
D

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.
 
J

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
'====================================================
 

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

Top