This is probably simple but:

The following portion of an SQL statement that I've copied from the SQL
view of the query grid (the query works fine) is giving me an error to
the effect that it is expecting an "end of statement" after the first
quotation mark before the word "Fail". From my very limited knowledge
of SQL, I'm assuming that it sees the first quotation mark as the end
of the statement. How can I remedy this?

strSQL = strSQL & " WHERE (((Data.Name) =
[Forms]![HistoryQInput]![TxtName]) And ((Data.DeviceNo) =
[Forms]![HistoryQInput]![TxtDeviceNo]) And ((Data.Result) = "Fail")) Or
(((Data.Name) = [Forms]![HistoryQInput]![TxtName]) And ((Data.DeviceNo)
= [Forms]![HistoryQInput]![TxtDeviceNo]) And ((Data.ResultAlc) =
"Fail"))"

Any help would be appreciated.

Use single quotes around both Fails instead of double quotes.

--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
resource (AT) pcdatasheet (DOT) com
www.pcdatasheet.com


"Wayne" <cqdigital (AT) volcanomail (DOT) com> wrote

Thanks for the help.