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.