Null Values?

  • Thread starter Thread starter Guest
  • Start date Start date
G

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.
 
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.
 
Cheers for the tip!


[MVP] S.Clark said:
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.
Click to expand...
 
Back
Top