Results 1 to 2 of 2
  1. #1
    Star Lounger
    Join Date
    Mar 2004
    White Oak, Pennsylvania, USA
    Thanked 0 Times in 0 Posts

    Multiple Criteria Requests (2002 - SP3)

    We have a query that links two tables. The two tables are a table of names and a table of marriage dates, each indexed by a Family Number and a Member Number ID (these two fields make up the index for the Names table).

    The query has a criteria that asks the operator to enter a date to use to select records from the marriage date table.

    The difficulty is that the criteria asks for the date 4 times. Is there a reason for this and a way to have the criteria question occur only once?

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Thanked 31 Times in 31 Posts

    Re: Multiple Criteria Requests (2002 - SP3)

    Without knowing the design of the query I can't tell why the query prompts four times, but the solution is usually to create a form (say frmParameter) with a text box (say txtDate) whose Format has been set to Medium Date or another date format. Replace the parameter in the query with a reference to the text box, i.e. if you have [Enter the Date] in the criteria of the query, change it to [Forms]![frmParameter]![txtDate] (using the names that you gave the form and text box.
    The user must open the form and enter a date, then open the query or a form or report based on the query. This could be done from a command button on the frmParameter form.

Posting Permissions

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