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.




Reply With Quote