Hi All
I am having problems with Dlookup from a table which is linked to Excel.
The heading on the fields from Excel have been imported as
F1, F2, F3 etc... the code I am using is as follows .....
LOOK = DLookup("F6", "DATABASE_LOOKUP", "F1 = 1338087")
F6 = A date I am looking up.
DATABASE_LOOKUP = table I am looking up.
F1 = 1338087 = The record I am looking for.
Error is Run-time 3464.
Data type mismatch in criteria expression.
Thanks
I am having problems with Dlookup from a table which is linked to Excel.
The heading on the fields from Excel have been imported as
F1, F2, F3 etc... the code I am using is as follows .....
LOOK = DLookup("F6", "DATABASE_LOOKUP", "F1 = 1338087")
F6 = A date I am looking up.
DATABASE_LOOKUP = table I am looking up.
F1 = 1338087 = The record I am looking for.
Error is Run-time 3464.
Data type mismatch in criteria expression.
Thanks