Results 1 to 2 of 2
2001-08-26, 23:39 #1TonyMGuest
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.
2001-08-27, 00:58 #2
- 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.