Criteria for table query & 5 tables

P

Paul B.

I need to build a query to either open a report or build a table that will
open the report, not sure which way to do this.

I have a main table (tblEpistry) and 4 unit tables (tblUnit1 through
tblUnit4).

I need to look at 2 fields in each tblUnit#, [CAMT] and [FORM2], if either
or both are blank, then I need that row.

Because each row in the tblEpistry has a Yes/No field to indicate if there
is data for the corresponding tblUnit#, there could be up to four rows from
the unit tables.

My question is, how would I build the criteria in the query to ensure I
catch each unit row that has a blank CAMT or FORM2 field?

Thanks in advance for any assistance.
 

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

Similar Threads

Sorting Multiple Tables 1
How to change WHERE part of query 0
Append Crosstab Query to Existing Table 0
Creating a Chart on form from selected data in query. 0
Need help with Percentages 0
Setting column width in a table with a macro is not working 0
Dealing with a Pivot Table (when I don't want to) 0
Trying to create a report that will list unmatched records by Ticket Primary Key 0

Top