Results 1 to 2 of 2
  1. #1
    Join Date
    Jun 2011
    Posts
    1

    Unanswered: [Enter Data] in query

    I have created a query with the criteria set to [Enter Data], Im also using the criteria [Enter Date]. When I run the query I first get asked to enter the date and then to Enter the data. It works how I want it...however what I want now is for it to ask me to enter more data. For example:

    Is is possible to repeat the criteria [enter data] so it can find the other data to in the query. Like I want it to find all the surname's with smith and then
    bloggs and maybe other's after...

    thanks for your help in advance.

  2. #2
    Join Date
    May 2010
    Posts
    601
    I would use you to use a form to collect the criteria. This will also allow you to validate the data or and other UI tools to help the user like a calendar.

    See: Microsoft Access tips: Search criteria
    Boyd Trimmell aka HiTechCoach HiTechCoach.com (free access stuff)
    Microsoft MVP - Access Expert
    BPM/Accounting Systems/Inventory Control/CRM
    Programming: Nine different ways to do it right, a thousand ways to do it wrong.
    Binary--it's as easy as 1-10-11

Posting Permissions

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