Results 1 to 2 of 2

Thread: Access Query's (easy)

  1. Nov 4th, 2003, 04:42 PM #1
    cid
    cid is offline

    Thread Starter
    Fanatic Member cid's Avatar
    Join Date
    Nov 2002
    Location
    Fort Worth, Texas
    Posts
    854

    Access Query's (easy)

    I want to create a query in msaccess(in the design view). I want the query to display numbers 4-7 only.
    Now in the criteria box I've tried "4"-"7" and I tried Between #4#-#7#.
    But neither of those worked does anyone know how to create a query in the design view that will display only numbers between 4 and 7

    www.google.com - Pay Tribute.

    Always Listening To: Thrice
    Reply With Quote Reply With Quote
  2. Nov 4th, 2003, 10:00 PM #2
    D12Bit
    D12Bit is offline
    Hyperactive Member D12Bit's Avatar
    Join Date
    Oct 2000
    Location
    Guatemala
    Posts
    373
    in the filter select the field with the value and type:
    >=4 And <=7

    that's it
    "Who Dares Wins" - "Quien se Arriesga Gana"
    Mail me at:
    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