Criteria not working

[MFS]

I have four Queries that show supply data from today and the past 2 hours as the Criteria. And another Criteria that states a 1, 2, 3 or 4. (Four Queries)
This issue I'm having is that all Queries are working great except for the #3. Does not make any sense. All the data is supplied to the Queries from the same table.
A copy of my Query . . .

When I do run the Query I get the following statement . . .
"Data type mismatch in Criteria expression"



Hopefully someone can help.

[JoeM]

What is the format of your date1 and time1 fields?
What do their entries look like?

If you remove the Criteria, does your function:
CDate([date1] & " " & [time1])
return valid looking values for EVERY record?

[MFS]

Format is military time, HH:mm
Yes, When I remove the Criteria all data looks fine.
If I copy a working Query like the one for 2, then change the Field Zone1 to a 3 it craps out.
The Dates and Times in the table are exactly the same as well.

[JoeM]

I didn't even see the Criteria under "zone1".
What is the format of the "zone1" field?

Try to figure out which field's criteria is causing the issue. That should be pretty easy.
Try removing the criteria under "zone1". Does it work? If so, then that criteria is the issue.
Otherwise, try removing the criteria under your date/time calculation and see if that works.

[MFS]

Copy of my table . .

[MFS]

Criteria under date time is what is causing it. But why for only zone 3
All others work perfectly fine. (Zone 3 has the same dates and times)

[JoeM]

Your date1 and time1 fields look like they are left justified. That usually indicates that the format of those fields is Text, not Date/Time.
That means you could have entries in there that are NOT valid dates or times. My guess is that you have a "bad" entry somewhere in there for one of your Zone 3 records.

Where is this data coming from?
Is it being imported?
What are the fields set up to be Date/Time fields instead of Text?
Then you would catch any issues upon importing the data.

[MFS]

Ahh, I see what your saying, okay, let me snoop around and I'll post what I come up with.