applying criteria to 2 fields in different tables

[dawnnolan54]

i am trying to create a query in which only records will appear if a certain condition is True in 1 table or a certain condition is True in another table. I have them linked by id, but how do i formulate the query to check for the "or" conditions on 2 different fields in 2 different tables.

[orange]

Use the query grid, add your tables, identify the fields, establish the join , add the criteria -- use different lines for the criteria to get the OR condition.

[dawnnolan54]

I think I am doing that. Attached is screenshot of query design view where i want to display the fields in all records in names that members are true and all records in pubs that defend-comp is true. I am not getting the results i want.

[orange]

What is in email criteria?
You have something in the grid that you didn't mention in your post.

"" is not the same as IS NOT NULL

[dawnnolan54]

i was checking if the field was blank or not or contained something. Is that not the correct way?

[June7]

If you allow empty strings in a text field, then the field could have a (visible) alphanumeric value, or could have (not visible) empty string value, or could be Null. Null means there is absolutely nothing, not even empty string.

I never allow empty strings in fields. So I use Is Not Null as criteria.

[orange]

@dawn,

You have to spend some time on the basics. Some of these are not self evident.

see this as a start.
Use Google or Bing to research
Empty string
ZLS
NULL
data type in the context of MSACCESS

Good luck.