Showing information in report from query where a field is NOT satisfied

[BringTheR41n]

I am trying to create a report that will show me any record that does NOT have a specific field met. I have a basic query set up to display the information desired, but need it to refine the search to just the records missing a specific part in a different table. The missing information does not have to be shown in the report. Any help is appreciated.

[June7]

Do these tables have PK/FK relationship? If not, maybe a DLookup will accomplish what you need.

Can't be more specific without knowing data structure.

[BringTheR41n]

I know its been a while for me to respond but yes the tables have fk. I have 3 tables; table 1 has relationship with 2 and 2 has relationship with 3. I need to show all files that are missing one part of table 3 but with data from table 1 (like jobs still in progress). Is there any way to use "iif" in this situation? and if so how would i set it up?

[June7]

Which table is primary and which is dependent?

What 'one part'? How many 'parts' should there be?

Provide example data. If you want to provide db, follow instructions at bottom of my post.

[BringTheR41n]

in table 1 i have jobs, part number, price,etc.
Table 2 has fkjobs, fkinvoice number
Table 3 has invoice number, invoice date, and other misc data.
every job has just a basic number to it but only completed jobs have an invoice. table 2 connects the jobs with an invoice. So, my goal is to create a report with this information of only the jobs WITHOUT an invoice to see what jobs are ongoing.

As for the 'how many part' question, there isnt a set number of parts. i was just trying to simplify things but it just made it worse. i only meant that there is other data in these tables that is irrelevant to my problem.

[June7]

Sounds like a Find Unmatched query. There is a wizard for that.

[BringTheR41n]

so for the information i have in my tables above, which two tables would i use? i am not familiar with this type of query

[June7]

Really need a table that lists JobID as a unique value. Is that table 1?

You want to know which jobs do not have invoice? Try using tables 1 and 2.