Results 1 to 5 of 5

Thread: SELECT Statement problem RESOLVED

Threaded View

  1. #1

    Thread Starter
    Member
    Join Date
    Mar 2004
    Location
    Miami FL
    Posts
    38

    SELECT Statement problem RESOLVED

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

    VB Code:
    1. 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.
    Last edited by WannabePBA; Apr 19th, 2004 at 02:50 PM.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width