Need help with setting a Parameter in a query!

[TannerLittle44]

I have a table query and I have a column called Class codes which contain SK8G, SNOW, VAS1A, VAS3A, VAS3B, and CFL1. I want the query to have a parameter to only pull records with "CFL1". I added my column to the criteria in the query and it was set to equal "CFL1". Then I try to return the data back to excel and I get an error code stating "Could not obtain parameter from reference(Bad name or workbook not open). Any Help with this?


Thanks!

 

[CastroTheCat]

It's a swing in the dark, but it might have to do with your column name.

SQL will look at your query and call it TableName.Class, which might confuse it into thinking it's looking up some sort of object class.

Could be wrong.





"I'm not a genius. I'm a chicken"
Pinky Pie