I've got 2 queries; the first query has a calculated column which uses the
DateValue function. the 2nd query attempts to filter results of the first
query using a date range
In the first query I've got this field:
dt_srch: DateValue([year] & "/" & [month] & "/" & [day]).
In the second query I attempt to filter results of the first in this
manner:
>=[Forms]![Frm_Rpts]![cmb_dt_fr] And <=[Forms]![Frm_Rpts]![cmb_dt_to] in
the criteria field for dt_srch
The 2nd query shows the following error message when run: "Data type
mismatch in criteria expression" then the results window is filled with
"#Name?" in all fields.
What could be causing this? The first error runs without issue and
displays
the dates properly.
