NULL function is not working for me

P

pht204

I am trying to run a query with tblEmployee and tblDeactivateDate.
tblDeactivateDate contains date and time of an employee when he/she
parts from the company. The query should give me all employees, who
are still working for me (in other words. DeactivateDate is empty
field). when I query both tables and put my parameter for
tblDeactivateDate is NULL, I still get a list of those with their dates
in my result. what gives? is there another way to check why this is
not working?
 
K

Keith W

I am trying to run a query with tblEmployee and tblDeactivateDate.
tblDeactivateDate contains date and time of an employee when he/she
parts from the company. The query should give me all employees, who
are still working for me (in other words. DeactivateDate is empty
field). when I query both tables and put my parameter for
tblDeactivateDate is NULL, I still get a list of those with their dates
in my result. what gives? is there another way to check why this is
not working?
Click to expand...
Is this a stored query or on executed in VBA code?

Keith.
www.keithwilby.com
 
J

John Vinson

I am trying to run a query with tblEmployee and tblDeactivateDate.
tblDeactivateDate contains date and time of an employee when he/she
parts from the company. The query should give me all employees, who
are still working for me (in other words. DeactivateDate is empty
field). when I query both tables and put my parameter for
tblDeactivateDate is NULL, I still get a list of those with their dates
in my result. what gives? is there another way to check why this is
not working?
Click to expand...

Care to give us a little help here? You can see your query; we cannot.
Please open it in SQL view and post the SQL text here.

John W. Vinson[MVP]
 
Top