Query problem

D

Delboy

I have a query that reports on incomplete jobs which queries, is the
delivery date field filled in? Now, i want the jobs to stay on the
incomplete jobs form unless three field are filled in delivery date,
Invoice amount, and invoice no.
I've tried putting 'is null' in all three but even if one is filled in
and not the others the job disappears from the report.
Anyone got any suggestions!
Thanks
 
N

Nikos Yannacopoulos

Delboy,

I assume you are putting your criteria in the grid, in the query design
view? If yes, you need to take into account that criteria put in the
same row are linked together with AND 's, so they all have to be
satisfied. In your case, you want the query to return records where at
least one is satisfied, i.e. you need OR 's instead. To achieve this,
each criterion must be put on a separate line in the grid.

Tip: switch to SQL view to see the SQL expression; look at the WHERE
clause in both cases, it will help you understand the difference.

HTH,
Nikos
 
K

Keith

Delboy said:
I have a query that reports on incomplete jobs which queries, is the
delivery date field filled in? Now, i want the jobs to stay on the
incomplete jobs form unless three field are filled in delivery date,
Invoice amount, and invoice no.
I've tried putting 'is null' in all three but even if one is filled in
and not the others the job disappears from the report.
Anyone got any suggestions!
Thanks
Click to expand...
Sounds like you need the null conditions to appear on the "or" lines of the
query grid, not the "and" lines, so that all three null conditions need to
be met before a record is excluded.

HTH - Keith.
www.keithwilby.com
 
Top