• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 254
  • Last Modified:

creating a query with different criteria

hello-
am attaching sample db.
when it opens- a form displays-
if you select 8/29/2011 in Text1
and select 9/2/2011 in Text3
Then click preview report button - a report displays 2 people jones and jackson.
question:
Is there a way in this sample- to create another query to display only jones?
and second form?
thank you,
Dan
( for some reason maybe the way I have form- i have been unable to create a second form and query that will work).
2time-database..accdb
0
davetough
Asked:
davetough
1 Solution
 
mbizupCommented:
Use the same form and query.

- Add a combo for Last Name on your form
- Modify your query, by setting the criteria for fName to:

Like Nz([Forms]![frmReportGenerator]![YourNewLastNameCombo],"*")
0
 
davetoughAuthor Commented:
tkhanks worked great
0

Featured Post

Prep for the ITIL® Foundation Certification Exam

December’s Course of the Month is now available! Enroll to learn ITIL® Foundation best practices for delivering IT services effectively and efficiently.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now