Null Values

Topic

New Reply

I have a query that counts the number of records that have a certain field populated with “Y” on a per user basis. I want to have all users listed with their counts, even if their count is zero. Currently, I only get users who have a count greater than 0. Any thoughts?

I have attached a screen shot of my query design. It’s data source is the results of another query.

I have tried various things to force all users to be lists, but no success.

Reply | Quote

Replies

try using NZ with the field names
NZ[field name]

Reply | Quote

I can’t see your screen shot, but basically if the query is showing only the users who have a count >0, use this query (I’ll call it the Count query) in a new query. In that new query place the User table and link it to your Count query with an outer join, so that you see all User table records, regardless of their existence in the Count query. Place all the fields in the grid that you additionally need to see.
HTH
By the way, how can I see that screen shot?

Reply | Quote

It isn’t your browser or the Lounge, the attachment isn’t there.

Reply | Quote