Microsoft Access
--
Questions
--
Followers
Top Experts
Access query does not display records with empty fields - Can you help please
I have a query that gets its criteria values from a form.
I have cleared the form so there are no filters/constraints. That means Combo405 and Combo406 "below" are empty (set equal to "").
However when any field in the table is empty, that record does not show up in the query.
For instance i have two records with the same [Property] value, but one does not have a value in the [Owner] field. Then my query only displays the record that has a property value and a Owner value in the underlying table.
My query looks like below.
I have cleared the form so there are no filters/constraints. That means Combo405 and Combo406 "below" are empty (set equal to "").
However when any field in the table is empty, that record does not show up in the query.
For instance i have two records with the same [Property] value, but one does not have a value in the [Owner] field. Then my query only displays the record that has a property value and a Owner value in the underlying table.
My query looks like below.
Zero AI Policy
We believe in human intelligence. Our moderation policy strictly prohibits the use of LLM content in our Q&A threads.
use NZ(MyField) for those fields
TheOwner: Nz( [Owner]) '<-- this inserts empty string for the missing owners.
or
TheOwner: Nz( [Owner],"tbd")
TheOwner: Nz( [Owner]) '<-- this inserts empty string for the missing owners.
or
TheOwner: Nz( [Owner],"tbd")
Hi,
My database design view now looks like below. The query now includes even those records without values. Thanks.
But now the query is not updatable anymore, because I changed all the names adding an X after the name. If I keep the query field names the same I get a circular reference error.
Is there a way that I can still keep the query updatable?
Please what do you mean by the "tbd"?
My database design view now looks like below. The query now includes even those records without values. Thanks.
But now the query is not updatable anymore, because I changed all the names adding an X after the name. If I keep the query field names the same I get a circular reference error.
Is there a way that I can still keep the query updatable?
Please what do you mean by the "tbd"?
ASKER CERTIFIED SOLUTION
membership
Log in or create a free account to see answer.
Signing up is free and takes 30 seconds. No credit card required.
Thanks a lot.
EARN REWARDS FOR ASKING, ANSWERING, AND MORE.
Earn free swag for participating on the platform.
Microsoft Access
--
Questions
--
Followers
Top Experts
Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.