qGOLOM, part 3 - error in Select statement

[Kurt6905]

Hello,

Concerning the following Select statement, I get an error message when I try to create a make-table query with it saying "The SELECT statement includes a reserved word or an argument name that is misspelled or missing, or the punctuation is incorrect." What doesn't Access like?

Thanks.


SELECT License, County, Percent, EPA_Reg, Brandname, Chem, Active, Pestcode
FROM qUNION_COUNTY;

 

[PHV]

SELECT License, County, [!][[/!]Percent[!]][/!], EPA_Reg, Brandname, Chem, Active, Pestcode
FROM qUNION_COUNTY;

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