Null Values?

[Guest]

Hi can anyone help?

I'm trying to create a query to do a count from a field with a list. It
works but it does not account for the options in the list that has not be
chosen. I would like it to show the option name and apply zero count to it.

So when I produce a report I can show all the options from the field.

Thank you in advance.

 

[[MVP] S.Clark]

This typically requires an outer join to a table that holds ALL of the
possible values. Such as Categories to Products, States to Orders, etc.

If you do not have this type of table, then I would suggest that you make
it.

 

[Guest]

Cheers for the tip!

This typically requires an outer join to a table that holds ALL of the
possible values. Such as Categories to Products, States to Orders, etc.

If you do not have this type of table, then I would suggest that you make
it.