Runtime error 3075 with SQL statement

MARTINQC

"SELECT [HPD:HelpDesk].[Case-ID+], [HPD:HelpDesk].Category
INTO tblSiteGroupActiveTicketRawData FROM [HPD:HelpDesk
WHERE (([HPD:HelpDesk].Base = 'AAAA') OR ([HPD:HelpDesk].Base = 'BBBB')) AND ([HPD:HelpDesk].Status != 'Closed');"

Above SQL string fails with a runtime error 3075 syntax error (operator missing). I cannot figure this one out. Any assistance would be appreciated.

JKing

Quote:

Originally Posted by MARTINQC

"SELECT [HPD:HelpDesk].[Case-ID+], [HPD:HelpDesk].Category
INTO tblSiteGroupActiveTicketRawData FROM [HPD:HelpDesk
WHERE (([HPD:HelpDesk].Base = 'AAAA') OR ([HPD:HelpDesk].Base = 'BBBB')) AND ([HPD:HelpDesk].Status != 'Closed');"

Above SQL string fails with a runtime error 3075 syntax error (operator missing). I cannot figure this one out. Any assistance would be appreciated.

Hey there,

At a quick glance it looks like you're missing a closing bracket on your FROM line.

"SELECT [HPD:HelpDesk].[Case-ID+], [HPD:HelpDesk].Category
INTO tblSiteGroupActiveTicketRawData
FROM [HPD:HelpDesk]
WHERE (([HPD:HelpDesk].Base = 'AAAA') OR ([HPD:HelpDesk].Base = 'BBBB')) AND ([HPD:HelpDesk].Status != 'Closed');"

MARTINQC

I'm pretty sure that is a typo on my part in the forum as it is there in the actual string.

SELECT [HPD:HelpDesk].[Case-ID+], [HPD:HelpDesk].Category INTO tblSiteGroupActiveTicketRawData FROM [HPD:HelpDesk] WHERE (([HPD:HelpDesk].Base = 'AAAA') OR ([HPD:HelpDesk].Base = 'BBBB')) AND ([HPD:HelpDesk].Status != 'Closed');

I think I erased the bracket when I formatted it for easier reading. The string above is a direct cut/paste from the query.

jaxjagfan

Quote:

Originally Posted by MARTINQC

I'm pretty sure that is a typo on my part in the forum as it is there in the actual string.

SELECT [HPD:HelpDesk].[Case-ID+], [HPD:HelpDesk].Category INTO tblSiteGroupActiveTicketRawData FROM [HPD:HelpDesk] WHERE (([HPD:HelpDesk].Base = 'AAAA') OR ([HPD:HelpDesk].Base = 'BBBB')) AND ([HPD:HelpDesk].Status != 'Closed');

I think I erased the bracket when I formatted it for easier reading. The string above is a direct cut/paste from the query.

Is "Status !" a field name?

SELECT [HPD:HelpDesk].[Case-ID+], [HPD:HelpDesk].Category INTO tblSiteGroupActiveTicketRawData FROM [HPD:HelpDesk] WHERE ([HPD:HelpDesk].Base IN ('AAAA', 'BBBB')) AND ([HPD:HelpDesk].[Status !] = 'Closed');

Just a habit but changed the OR to IN. Also make sure those same columns exist in "tblSiteGroupActiveTicketRawData " as they are in "HPD:HelpDesk". If not use "AS" to rename the "HPD:HelpDesk" columns.

The special characters (:,-,+,!) are not good to have as field names and makes things a bit more difficult to develop reports, queries, and to reference elsewhere.

JKing

Quote:

Originally Posted by MARTINQC

I'm pretty sure that is a typo on my part in the forum as it is there in the actual string.

SELECT [HPD:HelpDesk].[Case-ID+], [HPD:HelpDesk].Category INTO tblSiteGroupActiveTicketRawData FROM [HPD:HelpDesk] WHERE (([HPD:HelpDesk].Base = 'AAAA') OR ([HPD:HelpDesk].Base = 'BBBB')) AND ([HPD:HelpDesk].Status != 'Closed');

I think I erased the bracket when I formatted it for easier reading. The string above is a direct cut/paste from the query.

Try this..

Expand|Select|Wrap|Line Numbers

 
SELECT [HPD:HelpDesk].[Case-ID+], [HPD:HelpDesk].Category INTO tblSiteGroupActiveTicketRawData FROM [HPD:HelpDesk] WHERE (([HPD:HelpDesk].Base = 'AAAA') OR ([HPD:HelpDesk].Base = 'BBBB')) AND ([HPD:HelpDesk].Status NOT IN ('Closed'));

JKing

The != operator is not recognized as being a proper operator.

The correct syntax for this operator is <>.

Example:

Expand|Select|Wrap|Line Numbers

 
SELECT firstName, lastName

FROM tblPerson

WHERE firstName <> 'Bob'

Runtime error 3075 with SQL statement

re: Runtime error 3075 with SQL statement

re: Runtime error 3075 with SQL statement

re: Runtime error 3075 with SQL statement

re: Runtime error 3075 with SQL statement

re: Runtime error 3075 with SQL statement

Similar Microsoft Access / VBA bytes

/bytes/development

/bytes/it

/bytes/about