Results 1 to 3 of 3

Thread: Two Parameters

  1. #1
    Join Date
    Nov 2005

    Unanswered: Two Parameters

    I have a report called ParamForm. ParamForm is based off of a query called ParamQuery. The ParamQuery has three parameter criterias that it is looking for based off of the controls on the ParamForm (txtStartDate, txtEndDate, type).
    I know that if I type:
    strParameter = "SELECT * Forms!ParamForm!cmdCombo "
    that it will give me the item that a user has selected in the combobox (cmdCombo).

    My question is: How do I get all three parameters to be set as a criteria all at one time. Thank you.

  2. #2
    Join Date
    Dec 2002
    Préverenges, Switzerland
    this includes a demo search form that will collect any number of criteria (including zero criteria) from a form and get them into SQL.

    currently using SS 2008R2

  3. #3
    Join Date
    Nov 2005

    Smile Multiple Parameters

    I figured it out. Thank you so much for your assistance.
    Last edited by miracleblake; 12-15-05 at 10:59. Reason: :) Figured it out

Posting Permissions

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