Results 1 to 5 of 5

Thread: SELECT Statement problem RESOLVED

  1. Apr 19th, 2004, 02:06 PM #1
    WannabePBA
    WannabePBA is offline

    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.
    Reply With Quote Reply With Quote
  2. Apr 19th, 2004, 02:23 PM #2
    techgnome
    techgnome is offline
    PowerPoster techgnome's Avatar
    Join Date
    May 2002
    Posts
    34,687
    It would help if you also gave us what the error is...

    TG
    * I don't respond to private (PM) requests for help. It's not conducive to the general learning of others.*
    * I also don't respond to friend requests. Save a few bits and don't bother. I'll just end up rejecting anyways.*
    * How to get EFFECTIVE help: The Hitchhiker's Guide to Getting Help at VBF - Removing eels from your hovercraft *
    * How to Use Parameters * Create Disconnected ADO Recordset Clones * Set your VB6 ActiveX Compatibility * Get rid of those pesky VB Line Numbers * I swear I saved my data, where'd it run off to??? *
    Reply With Quote Reply With Quote
  3. Apr 19th, 2004, 02:26 PM #3
    WannabePBA
    WannabePBA is offline

    Thread Starter
    Member
    Join Date
    Mar 2004
    Location
    Miami FL
    Posts
    38
    Yeah, it could help.

    "No value given for one or more required parameters"
    Reply With Quote Reply With Quote
  4. Apr 19th, 2004, 02:42 PM #4
    kovan
    kovan is offline
    Frenzied Member
    Join Date
    Aug 2000
    Posts
    1,539
    i would make sure you typed the field names correctly
    seems like a spelling mistake

    Developer News
    Developer Toolz
    Free C# iCodeLibrary - Code Organizer - WITH FREE CODE

    Free Developer Toolz | Hire Me as a Consultant | C# 4 Unix | Free C# Books | |
    Reply With Quote Reply With Quote
  6. Apr 19th, 2004, 02:50 PM #5
    WannabePBA
    WannabePBA is offline

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

    Select Statement problem RESOLVED

    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
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules


Click Here to Expand Forum to Full Width