Syntax Error HELP!!!

[Valentine]

Can someone help me find the error in this:

SELECT Cnf.[Customer Organization], Cnf.[CNF ID#], Cnf.Title, Cnf.Status
FROM Cnf
WHERE ((Cnf.Status) Like "*SAVED*" Or (Cnf.Status) Like "*With*" Or (Cnf.Status) Like "*Submitted*" Or (Cnf.Status) like "*QA/QC*");

 

[theDBguy]

For starters, try removing all the parens from the SQL statement to make sure they're not imbalance.

 

[Valentine]

so i have no idea what changed but through my panic i just copied the one that was working from my test DB to the Live DB and now it works......That is exactly what i did when i created the query in the first place....

 

[theDBguy]

As long as it works. Good job!

 

[LarryE]

Can someone help me find the error in this:

SELECT Cnf.[Customer Organization], Cnf.[CNF ID#], Cnf.Title, Cnf.Status
FROM Cnf
WHERE ((Cnf.Status) Like "*SAVED*" Or (Cnf.Status) Like "*With*" Or (Cnf.Status) Like "*Submitted*" Or (Cnf.Status) like "*QA/QC*");

To avoid further problems, never, ever, ever use special characters such as # in a field name or table name or any name. Use them in labels on forms and reports only. So get rid of the # in Cnf.[CNF ID#]. You can use underlines ( _ ) though. Spaces are not recommended either. So, Cnf.[CNF ID#] should be Cnf.[CNFID] or Cnf.[CNF_ID]. ACCESS uses # for special purposes.

 

[Gasman]

so i have no idea what changed but through my panic i just copied the one that was working from my test DB to the Live DB and now it works......That is exactly what i did when i created the query in the first place....

Would be better to post within code tags as well ?