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

    Unanswered: enter single parameter for multiple queries

    I have a report comprised of two subreports (eventually 4 or 5 if I can get this to work), each based on an individual query. The parameter for each query would be the same date but from different fields in different record sources (tables). I'm trying to figure out a way to prompt the user for the particular date once to be used by all the queries subsequently producing appropriate subreports and final report.

    Suggestions?

  2. #2
    Join Date
    Jan 2004
    Location
    Australia
    Posts
    15
    One way that you could do this is to create a form which has a text box so the user can enter a date and a command button to open up the report. From this each recordset on each subreport can reference the text box on the form.

    This would be the criteria you will use in your queries on the date fields.
    [Forms]![NameOfYourForm]![NameOfYourTextbox]

    There are quite a few different ways of doing this but I believe that this way is probably the easiest.

Posting Permissions

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