G
Guest
Hi Everyone,
I have a date field DD/MM/YYYY HH:mm:SS in a table. I want to select rows,
in a query, based on "between" StartDate and EndDate. Frustration!
I've built parameters for the two, and on execution the query prompts me for
Startdate and Enddate parameters but I keep getting "Data Type mismatch"
errors.
I've simplified the query criteria to just = "Startdate" but keep getting
the same problem.
All help appreciated
Pat.
I have a date field DD/MM/YYYY HH:mm:SS in a table. I want to select rows,
in a query, based on "between" StartDate and EndDate. Frustration!
I've built parameters for the two, and on execution the query prompts me for
Startdate and Enddate parameters but I keep getting "Data Type mismatch"
errors.
I've simplified the query criteria to just = "Startdate" but keep getting
the same problem.
All help appreciated
Pat.