Expression is too complex to be evaluated/data type mismatch

[Guest]

Hi,
This query always ran perfectly. Out of the blue, it I started getting this
error...it is on the query field RptDate: ([DateStart]). I retyped it and
now I get data in the query, but the report doesn't want to work anymore. Has
anyone ever seen this before? Thanks! So frustrating... I even recopied from
a back up, the reports and queries it's the same thing. I even tried to look
at data in the tables and I couldn't see anything.

 

[Ken Snell \(MVP\)]

With dates, that error message often is caused by an improper date format
when being entered by hand (query parameter prompt) or incorrect date value
("negative" date value) in the data. I'd take a good look at your table's
data if the date values are stored there and verify that all date data are
valid.

 

[Guest]

I checked the dates, they seem to be fine... it's date/time format. Any other
suggestions?

With dates, that error message often is caused by an improper date format
when being entered by hand (query parameter prompt) or incorrect date value
("negative" date value) in the data. I'd take a good look at your table's
data if the date values are stored there and verify that all date data are
valid.
--

Ken Snell
<MS ACCESS MVP>

Hi,
This query always ran perfectly. Out of the blue, it I started getting
this
error...it is on the query field RptDate: ([DateStart]). I retyped it
and
now I get data in the query, but the report doesn't want to work anymore.
Has
anyone ever seen this before? Thanks! So frustrating... I even recopied
from
a back up, the reports and queries it's the same thing. I even tried to
look
at data in the tables and I couldn't see anything.

 

[Ken Snell \(MVP\)]

You'll need to give us more details about the query and the report. Let's
start with the SQL statement of the query.

--

Ken Snell
<MS ACCESS MVP>

I checked the dates, they seem to be fine... it's date/time format. Any
other
suggestions?

With dates, that error message often is caused by an improper date format
when being entered by hand (query parameter prompt) or incorrect date
value
("negative" date value) in the data. I'd take a good look at your table's
data if the date values are stored there and verify that all date data
are
valid.
--

Ken Snell
<MS ACCESS MVP>

Hi,
This query always ran perfectly. Out of the blue, it I started getting
this
error...it is on the query field RptDate: ([DateStart]). I retyped
it
and
now I get data in the query, but the report doesn't want to work
anymore.
Has
anyone ever seen this before? Thanks! So frustrating... I even recopied
from
a back up, the reports and queries it's the same thing. I even tried to
look
at data in the tables and I couldn't see anything.

 

[Guest]

Ken,
I got it! thanks!

You'll need to give us more details about the query and the report. Let's
start with the SQL statement of the query.

--

Ken Snell
<MS ACCESS MVP>

I checked the dates, they seem to be fine... it's date/time format. Any
other
suggestions?

With dates, that error message often is caused by an improper date format
when being entered by hand (query parameter prompt) or incorrect date
value
("negative" date value) in the data. I'd take a good look at your table's
data if the date values are stored there and verify that all date data
are
valid.
--

Ken Snell
<MS ACCESS MVP>



Hi,
This query always ran perfectly. Out of the blue, it I started getting
this
error...it is on the query field RptDate: ([DateStart]). I retyped
it
and
now I get data in the query, but the report doesn't want to work
anymore.
Has
anyone ever seen this before? Thanks! So frustrating... I even recopied
from
a back up, the reports and queries it's the same thing. I even tried to
look
at data in the tables and I couldn't see anything.