I am trying to create a custom report in access in which the users selects from a text box on a form the data field and the report displays that data. I am able to do this by embedding the form criteria into the criteria section of the query ie. [forms]![project]![status] in the query window. in the form project the user selects the project status "Green" and all the green projects appear. I want the user to be able to make a selection in which all projects appear (red, yellow, and green) I cannot seem to be able to embed the wildcard query Like "*" into the query, any suggestions on how to accomplish this.
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Westi on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Custom report in Access 97
- Thread starter jswe
- Start date
CosmoKramer
Programmer
Change the criteria to:
If [status] is null, then all records will be returned.
Hoc nomen meum verum non est.
Code:
Like [forms]![project]![status] & "*"Hoc nomen meum verum non est.
- Status
Similar threads
- Locked
- Question
- Locked
- Question