Re: Type mismatch in a criteria that used to work
- From: "Bob Barrows [MVP]" <reb01501@xxxxxxxxxxxxxxx>
- Date: Tue, 22 Jul 2008 10:23:47 -0400
John Spencer wrote:
SELECT [downtime 1].Date
, [downtime 1].DESCRIPTION
, Left([description],6) AS linetype
, [downtime 1].[reason code]
, [downtime 1].comments
, [downtime 1].duration
, [downtime 1].dtstart
, [downtime 1].dtfinish
, [downtime 1].dtevent
, [downtime 1].[start time]
, [downtime 1].[finish time]
, [downtime 1].shift
FROM [downtime 1]
WHERE [downtime 1].shift=[Forms]![Downtime Report]![Combo58] OR
[Forms]![Downtime Report]![Combo58] is Null
I suspect that the error is occuring in the DownTime 1 query.
That was my first thought, except he said the query runs fine without
the criterion.
--
Microsoft MVP -- ASP/ASP.NET
Please reply to the newsgroup. The email account listed in my From
header is my spam trap, so I don't check it very often. You will get a
quicker response by posting to the newsgroup.
.
- Follow-Ups:
- Re: Type mismatch in a criteria that used to work
- From: John Spencer
- Re: Type mismatch in a criteria that used to work
- References:
- RE: Type mismatch in a criteria that used to work
- From: RobD
- Re: Type mismatch in a criteria that used to work
- From: John Spencer
- RE: Type mismatch in a criteria that used to work
- Prev by Date: export query data to excel to create a mailer
- Next by Date: Re: Pull Data from Multiple CSV's
- Previous by thread: Re: Type mismatch in a criteria that used to work
- Next by thread: Re: Type mismatch in a criteria that used to work
- Index(es):
Relevant Pages
|
