Replacing Null values in a query with Text

[Ron_Mowry]

I have created an unmatched query that returns employees who are listed in my Sales table but are not listed in my employee list table. Now this query retunrs null data for manager since there is no manager field in the sales table. but I need this query to return a manager field and if there is no dat I would like to place "Unknown' text in that field. I have tried to use the NZ function to correct this issue Manager: nz(Employee_List.Manager,0) the only problem with this is when I try to initialize the query a dialog box pops up asking me to "Enter Perameter Data" for the manager field. If you could assist me I would greatly appreciate it.

 

[Husan]

try using:

nz(Employee_List.Manager,"Unknown")

and also you need to include the above field in yr query but dont display it.