Error message

[ielmrani via AccessMonster.com]

Hi,
I am trying to run Microsoft Access select query and I am getting the
following error message:
INVALID SQL STATMENT;EXPECTED 'DELETE, 'INSERT', 'PROCEDURE', 'SELECT', OR
'UPDATE'
Does anyone know the answer? Thanks in advance

ismail

 

[Guest]

Open the query in design mode.
From the View menu select SQL view.
Copy and paste the SQL into your post so we can look at the SQL.
It's probably a syntax error or something like that.

jmonty

 

[ielmrani via AccessMonster.com]

Here is the code:
Thanks
SELECT DISTINCT dbo_CSM_MASTERS_VS.CUSTPROVID, dbo_CSM_MASTERS_VS.CUSTNAME,
dbo_CSM_MASTERS_VS.CSINO, dbo_CSM_DETAILS_VS.RESPPER, dbo_CSM_MASTERS_VS.
INCTYPE, dbo_CSM_MASTERS_VS.SUBTYPE, Left([ACTION],1) AS [ACTType Grouper],
dbo_CSM_DETAILS_VS.ACTION, IIf([RESULT] Is Null,"N/A",[RESULT]) AS ResultCode,
dbo_CSM_DETAILS_VS.OPENDATE, dbo_CSM_DETAILS_VS.NOTES, dbo_PROV_SPECCODES_VS.
DESCR, [PCP Term -Member Total At TCode].[Members At TCode] AS Members
FROM (((dbo_CSM_MASTERS_VS LEFT JOIN dbo_CSM_DETAILS_VS ON dbo_CSM_MASTERS_VS.
CSINO = dbo_CSM_DETAILS_VS.CSINO) LEFT JOIN dbo_PROV_SPECINFO_HCVW ON
dbo_CSM_MASTERS_VS.CUSTPROVID = dbo_PROV_SPECINFO_HCVW.PROVID) LEFT JOIN
dbo_PROV_SPECCODES_VS ON dbo_PROV_SPECINFO_HCVW.SPECCODE =
dbo_PROV_SPECCODES_VS.CODE) LEFT JOIN [PCP Term -Member Total At TCode] ON
dbo_CSM_MASTERS_VS.CUSTPROVID = [PCP Term -Member Total At TCode].ProviderID
WHERE (((dbo_CSM_MASTERS_VS.CUSTPROVID)=[Enter Provider ID#]) AND (
(dbo_CSM_MASTERS_VS.INCTYPE) Like "PR") AND ((dbo_CSM_MASTERS_VS.SUBTYPE) In
("ACT","HIST")) AND ((dbo_PROV_SPECINFO_HCVW.TYPE)="PRIMARY"));

Open the query in design mode.
From the View menu select SQL view.
Copy and paste the SQL into your post so we can look at the SQL.
It's probably a syntax error or something like that.

jmonty

Hi,
I am trying to run Microsoft Access select query and I am getting the

[quoted text clipped - 4 lines]

ismail

 

[ielmrani via AccessMonster.com]

Never mind. Problem solved. I am getting the message because I have
Microsoft office 2003, another person who has Microsoft office 2000 did not
get the error..
thanks

Here is the code:
Thanks
SELECT DISTINCT dbo_CSM_MASTERS_VS.CUSTPROVID, dbo_CSM_MASTERS_VS.CUSTNAME,
dbo_CSM_MASTERS_VS.CSINO, dbo_CSM_DETAILS_VS.RESPPER, dbo_CSM_MASTERS_VS.
INCTYPE, dbo_CSM_MASTERS_VS.SUBTYPE, Left([ACTION],1) AS [ACTType Grouper],
dbo_CSM_DETAILS_VS.ACTION, IIf([RESULT] Is Null,"N/A",[RESULT]) AS ResultCode,
dbo_CSM_DETAILS_VS.OPENDATE, dbo_CSM_DETAILS_VS.NOTES, dbo_PROV_SPECCODES_VS.
DESCR, [PCP Term -Member Total At TCode].[Members At TCode] AS Members
FROM (((dbo_CSM_MASTERS_VS LEFT JOIN dbo_CSM_DETAILS_VS ON dbo_CSM_MASTERS_VS.
CSINO = dbo_CSM_DETAILS_VS.CSINO) LEFT JOIN dbo_PROV_SPECINFO_HCVW ON
dbo_CSM_MASTERS_VS.CUSTPROVID = dbo_PROV_SPECINFO_HCVW.PROVID) LEFT JOIN
dbo_PROV_SPECCODES_VS ON dbo_PROV_SPECINFO_HCVW.SPECCODE =
dbo_PROV_SPECCODES_VS.CODE) LEFT JOIN [PCP Term -Member Total At TCode] ON
dbo_CSM_MASTERS_VS.CUSTPROVID = [PCP Term -Member Total At TCode].ProviderID
WHERE (((dbo_CSM_MASTERS_VS.CUSTPROVID)=[Enter Provider ID#]) AND (
(dbo_CSM_MASTERS_VS.INCTYPE) Like "PR") AND ((dbo_CSM_MASTERS_VS.SUBTYPE) In
("ACT","HIST")) AND ((dbo_PROV_SPECINFO_HCVW.TYPE)="PRIMARY"));

Open the query in design mode.
From the View menu select SQL view.

[quoted text clipped - 8 lines]