Query Question with Zero Value

[Princessboko]

I have a database that I track customer complaints for each department and facility. At the end of each month each department gets a report that shows the date, type and number of complaints.

Now I need to write a query that will let me print a report for each department that DID NOT have a complaint for the month.

In an unbound box would it be:
If [complainttype]=" " then [location] ???

Feedback would be helpful.

 

[Ziggy]

Try

IIf ([complainttype] Is Null,[location],[ComplaintType])

Means:

IIf ([complainttype] Is Null,TRUE,FALSE)


If you want to put a text string use quotes instead of a field, In Access it is IIF not IF

 

[mdmilner]

You can also do this with a parameter for strings.

WHERE len(fieldname) = 0