SELECT Statement problem RESOLVED

OK, for some reason, I can't figure out what the mistake in this SQL SELECT statement is.

VB Code:

SELECT CatNum, ItemDesc, Quantity, Price FROM ItemList WHERE (ItemCategory = 'Misc')

The table name in Access is ItemList and the columns are named as above in the SQL statement. I'm probably missing something really simple and I'm just not seeing it.

It would help if you also gave us what the error is...

TG

Yeah, it could help.

"No value given for one or more required parameters"

i would make sure you typed the field names correctly
seems like a spelling mistake

Well, like I said, it was probably a stupid mistake. I found it. Wasn't a spelling problem, but I was trying to select from the wrong table