Dlookup

[Perfac]

With the following code i want to test in my new table if there are already items i have appended from the current query and in the field of each record it says "#Error" and when i click on the cell it displays an error of "The Expression you entered as a query parameter produced this error: 'The object doesn't contain the automation object 'Feb."

IIf(IsNull(DLookUp("WgeID","t03Wage","Employ_ID08= " & [EmployID] & " AND Wagedate02=" & [WageDate01])),0,1)

Don't know if i have to use '#" & Format(Wagedate02,"yyyy-mm-dd") & "#'
please help :3

[Minty]

If it's returning "Feb" it sound like your WageDate01 field has a string in it and not a date?

What is the data type?

[Perfac]

If it's returning "Feb" it sound like your WageDate01 field has a string in it and not a date?

What is the data type?

Date and Time(short date) example "01-Feb-2016"

[isladogs]

In that case you do need the date delimiters