Trying to Change a blank value in a Query

[Guest]

I import some data(call it the Financial Cube) from our mainframe into a
table. The financial cube uses a code for the employee name. I created a
table which contains the Employee Name and the code used in the Financial
Cube.

In a query, I use link the two tables on the code for the employee so that
the query can convert the employee code to a recognizable employee name.
Problem is that some of the employees, in the financial cube, are no longer
with the
company. Conseqently, the query returns invalid employee codes with the
Employee Name as blank space.

I'd like to change this blank space to "unknown" when I generate the report
using the query, so that I can group all the unknowns.
Any ideas.....? Thank you.

 

[Rick B]

See your post from 3:23 for the answer.

 

[MGFoster]

I import some data(call it the Financial Cube) from our mainframe into a
table. The financial cube uses a code for the employee name. I created a
table which contains the Employee Name and the code used in the Financial
Cube.

In a query, I use link the two tables on the code for the employee so that
the query can convert the employee code to a recognizable employee name.
Problem is that some of the employees, in the financial cube, are no longer
with the
company. Conseqently, the query returns invalid employee codes with the
Employee Name as blank space.

I'd like to change this blank space to "unknown" when I generate the report
using the query, so that I can group all the unknowns.
Any ideas.....? Thank you.

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Use the Nz() function:

Nz(EmployeeName, "Unknown")

This will only work if the EmployeeName column value is NULL. If the
EmployeeName value is an empty string, "", then use this:

IIf(Len(EmployeeName)=0, "Unknown", EmployeeName)

--
MGFoster:::mgf00 <at> earthlink <decimal-point> net
Oakland, CA (USA)

-----BEGIN PGP SIGNATURE-----
Version: PGP for Personal Privacy 5.0
Charset: noconv

iQA/AwUBQgfkH4echKqOuFEgEQJzPACg86SLB1kmO7PTPsMPMinPD/aY6hMAn2GY
is564I42JiBtZaWFh7cMiNNH
=Olbq
-----END PGP SIGNATURE-----