Error 3141 - SELECT statement ....

[Crookshanks]

Goodmorning, I have a litte syntax problem (I guess).
I know what the errop means but I can not figure out how to fix it. The error:

"The SELECT statement includes a reserved word or an argument name that is misspelled or missing, or the punctuation is incorrect. (Error 3141)"

Statement:
SELECT TSTFND_tbl_Batch.IdBatch, TSTFND_tbl_Batch.Type, TSTFND_tbl_Batch.EntryDate, TSTFND_tbl_Batch.UserEntry, TSTFND_tbl_Participants.Name, TSTFND_tbl_Participants.Initials, TSTFND_tbl_Participants.Insertion, TSTFND_tbl_Participants.Residence, TSTFND_tbl_Batch.Units, FROM TSTFND_tbl_Participants INNER JOIN TSTFND_tbl_Batch ON TSTFND_tab_Participtants.IdPar = TSTFND_tbl_Batch.IdPar;

TSTFND is a string variable that can be different in each session. Can anyone tell me what is wrong with the above?

Thanks in advance,

 

[gojohnnygogogogo]

is name reserved ?

try:
TSTFND_tbl_Participants.name AS P_Name,

 

[Crookshanks]

Thanks for you quick answer, but I do not know what you mean. The only thing that could be reserved is TSTFND, but that is nog een command / instruction in JET SQL.
Wat do you mean by P_Name?

 

[gojohnnygogogogo]

by doing AS P_Name ( or AS anything really) you are setting the name field to have the name P_Name

this way you are not using the reserved word name in your query.

 

[PHV]

Replace this:
TSTFND_tbl_Batch.Units, FROM
By this:
TSTFND_tbl_Batch.Units FROM

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244