Results 1 to 2 of 2
  1. #1

    Parameter with query by form (97 SR2)

    I am using a query by form for users to enter a parameter to generate a report. the form is underpinned by a query which has a field forms![frmSelectTrainingRecord]![ProcedureGrade]. The user is required to input a number from 0 -4. However I wish to have a less than sign in the query so that if a user inputs 4 they get all info of 4 or less. I can't seem to hit on the correct syntax to include in the query with the forms![frmSelectTrainingRecord]![ProcedureGrade] criteria.

  2. #2
    3 Star Lounger
    Join Date
    Dec 2000
    La Verne, California, USA
    Thanked 0 Times in 0 Posts

    Re: Parameter with query by form (97 SR2)


    Try putting <= in the criteria grid in front of "Forms!frmSelectTrainingGrade!ProcedureGrade" [no quotes].
    I naturally assume you are basing your report on this query as well.

    Hope this helps.

Posting Permissions

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