Results 1 to 5 of 5
  1. #1
    Join Date
    Mar 2003
    Posts
    2

    Unanswered: Need help with a query.

    I have a very simple table and I want to be able to have a query where I can search by customer name, PHone #, etc..... When I try to setup a query, it just lists every record in the table. How can I get it to just show the record or records that contain the data Im searching for?

    Thanks
    Philip

  2. #2
    Join Date
    Aug 2002
    Location
    Charlotte NC
    Posts
    665

    Re: Need help with a query.

    Originally posted by pooka16
    I have a very simple table and I want to be able to have a query where I can search by customer name, PHone #, etc..... When I try to setup a query, it just lists every record in the table. How can I get it to just show the record or records that contain the data Im searching for?

    Thanks
    Philip
    in the criteria line under the field that u want to search under put the specific thing that u are interested in ie phone number or customer name.
    that will filter the ones that u want out
    Jim

  3. #3
    Join Date
    Mar 2003
    Posts
    2

    Re: Need help with a query.

    I tried that but its still showing all records...........




    Originally posted by JDionne
    in the criteria line under the field that u want to search under put the specific thing that u are interested in ie phone number or customer name.
    that will filter the ones that u want out
    Jim

  4. #4
    Join Date
    Aug 2002
    Location
    Charlotte NC
    Posts
    665

    Re: Need help with a query.

    Originally posted by pooka16
    I tried that but its still showing all records...........
    take a look at the image im loading, it shows u what I mean.
    hopefully this will help. It shows me qualifying on a date column only wanting todays date

  5. #5
    Join Date
    Aug 2002
    Location
    Charlotte NC
    Posts
    665

    Re: Need help with a query.

    Originally posted by JDionne
    take a look at the image im loading, it shows u what I mean.
    hopefully this will help. It shows me qualifying on a date column only wanting todays date
    image didnt post lets try again
    Attached Files Attached Files

Posting Permissions

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