Re: dateadd embedded in dlookup problem

Could have been something as simple as EmployeeID being a text field and not
a number field?


"crusty via AccessMonster.com" <u26101@uwe> wrote in message
news:65ee3b2f0b1c4@xxxxxx
Thanks for the advise, John.
Still couldn't get it to work,
Time constraints led me to abandon the dLookUp and reworked Tables and
queries to avoid using it.

All working now.

Still don't know why it didn't work, maybe a bug?
Anyway, thanks again for your time and imput.

Regards
Adrian


John Spencer wrote:
Try a couple things.

--Use two quotation marks in place of the apostrophe.
--Use CDate around MDate to make sure MDate is being treated as a date.


--
Message posted via http://www.accessmonster.com



.