Nulls (1 Viewer)

[petercummins]

Hi there,

I have 4 fields in a table(Call_Freq, Call_Week, Call_Day, Call_Sequence)

I have to make a query that finds records with Null values in these fields.

If they are all null that is fine so I only want to return records with either one, two or three of the columns with Null values.

Any help would be appreciated.

 

[M8KWR]

in your design window

 

[M8KWR]

in your design window

 

[M8KWR]

quite simply need to do this backwards to get your results instead of looking for null values you need to look for entered value.

you can either go into your design window drag a drop all fields, and then under the first field in the criteria enter Is Not Null, then under the second field, but in the next criteria line donw do the same and keep going along all four field

or either edit the code below, i just created a table (table1) and labelled all my fields 1 2 3 & 4

SELECT Table1.[1], Table1.[2], Table1.[3], Table1.[4]
FROM Table1
WHERE (((Table1.[1]) Is Not Null)) OR (((Table1.[2]) Is Not Null)) OR (((Table1.[3]) Is Not Null)) OR (((Table1.[4]) Is Not Null));

any issues then please let me know