Categorizing Blank Cells as Unassiged

[Bob]

I have the following table below:

Org Grp Group1
Unassigned
BLBL Other
CAT Catalog
COMP Other
DIST Other
DIST-A Distribution
DIST-O Other
DIST-P Distribution
EUSR EU/OEM
FWD Other
GOVT Other
ICO ICO
OEM EU/OEM
SYS Other

I am doing a query with another table by joining Org Group and dropping in
Group1
into the query. What I would like to do is categorize the empty values in
Org Group as "Unassigned". when I do the query now, I get blank values for
both Org Group and Group1

Thanks.

 

[Stefan Hoffmann]

hi Bob,

I am doing a query with another table by joining Org Group and dropping in
Group1
into the query. What I would like to do is categorize the empty values in
Org Group as "Unassigned". when I do the query now, I get blank values for
both Org Group and Group1

hmm, I'm not quite sure that I understand it, but you can use the
following expression for the field where you like to have the
"unassigned" in:

Nz([yourField], "unassigned")


Place it into a new column in the query designer.



mfG
--> stefan <--

 

[Allen Browne]

Stefan suggested how to display the word unassigned. If you are joining Org
Group to another table, you will need to use an outer join.

If that's a new concept, double-click the line joining Org Group to your
other table. More info in:
The Query Lost My Records! (Nulls)
at:
http://www.allenbrowne.com/casu-02.html

--
Allen Browne - Microsoft MVP. Perth, Western Australia

Reply to group, rather than allenbrowne at mvps dot org.

hi Bob,

I am doing a query with another table by joining Org Group and dropping
in Group1
into the query. What I would like to do is categorize the empty values in
Org Group as "Unassigned". when I do the query now, I get blank values
for both Org Group and Group1

hmm, I'm not quite sure that I understand it, but you can use the
following expression for the field where you like to have the "unassigned"
in:

Nz([yourField], "unassigned")


Place it into a new column in the query designer.



mfG
--> stefan <--