Unanswered: Re-labelling Null groupings in Queries/Reports
I'm designing a query to list Categories (column A) and counts by category (column B). If the category is null, the query actually shows the combo box used to select a Category in the table! I was wondering if you could relabel this query output so that it lists as "(Null)" or something to that effect.
Category --- Count
First --- 7
Second --- 2
Third --- 12
The fourth row is all the instances where the category is not yet entered, but the location where I'd like to put in "(Null)"
This works. However, I am using a combo box lookup to show words rather than codes. When I add this NZ() code, "(Null)" appears appropriately but the other categories turn into codes, rather than words. Any way to modify this?