Results 1 to 4 of 4

Thread: Regarding query

  1. #1
    Join Date
    Mar 2008
    Posts
    11

    Unanswered: Regarding query

    Suppose there is a search screen which contains "Customer Name" and "Customer ID". While searching user can enter either customer name or customer ID or both. How to implement this using a query

  2. #2
    Join Date
    May 2003
    Location
    UK
    Posts
    233
    In your query enter the following in the criteria against each field.

    Like [Enter Customer Name or * for All]
    And
    Like [Enter Customer ID or * for All]

  3. #3
    Join Date
    Apr 2004
    Location
    metro Detroit
    Posts
    634
    Are you opening another form, filtering records on the same form, opening a report, or something else?

  4. #4
    Join Date
    Mar 2008
    Posts
    11
    Thanks ...its working

Posting Permissions

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