I have a large table of data in random order each row of which is dated. I need to be able to extract from this items which have dates between two givens. I was hoping to do this using MSQuery.
I can find the table in query and set the date range as the criteria. If I directly type the dates into the criterion area it works. However if I set the criteria using parameters (which I will need to do) I get an error " Invalid Character value for cast specification."
This error persists whatever format I use for the dates.
What am I doing wrong?
John
Bookmarks