G
Guest
I have a query that creates a date based on another date using the dateAdd
function. It looks like a date and you can do DatePart functions on it, etc.
BUT when you try to set up select using this field, I get a data type
mismatch error. It doesnt matter if you put in as a prompt and enter
something like 1-1-05 or hard-type it in the criteria line as 1-1-05,
#1/1/05#, etc.
What's with this function??? It walks like a duck, quacks like a duck but
it won't swim like a duck....
Best to a helpers!
RO
function. It looks like a date and you can do DatePart functions on it, etc.
BUT when you try to set up select using this field, I get a data type
mismatch error. It doesnt matter if you put in as a prompt and enter
something like 1-1-05 or hard-type it in the criteria line as 1-1-05,
#1/1/05#, etc.
What's with this function??? It walks like a duck, quacks like a duck but
it won't swim like a duck....
Best to a helpers!
RO