Results 1 to 2 of 2

Thread: Retreiving Data from Access

  1. Aug 14th, 2001, 01:53 PM #1
    BidForYourBiz
    BidForYourBiz is offline

    Thread Starter
    Member
    Join Date
    Jul 2001
    Location
    Phoenix, AZ
    Posts
    44

    Retreiving Data from Access

    I am trying to return the folling 7 rows form a row picked by the user. Its not working. I am new to SQL and any help is really appreiciated. Thanks in advance. Also, any code samples will really help.

    Here is my current statement

    Select top 7 * from Rates where Rate = '6'
    Reply With Quote Reply With Quote
  2. Aug 14th, 2001, 02:38 PM #2
    mdake
    mdake is offline
    Hyperactive Member
    Join Date
    Jul 2001
    Location
    FL
    Posts
    258
    Your syntax appears correct. Make sure your names are spelt correct and if Rate is not text then remove the single quotes from around it.

    like this...

    Select top 7 * from Rates where Rate = 6
    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