I have a query that I generated for a report. When I go to print the report I would like a box to come up that I can request several records from the same field. I have built a Laboratory database that holds sample information that is tied to a Chain of custody number. I would like to be able to request certain Chain of custody numbers to print out in a report. The numbers are not necessarily sequential, they could be all over the place. If you have an answer for this I would be so grateful.
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 Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Require Query to creat pop up box for user to fill in. 1
- Thread starter TamaraR
- Start date
-
1
- #2
tomschafer
Technical User
Add this as a criteria in the SQL, The blue is a parameter that will pop up, change the green to the name of the field in the table...
InStr([Custody Numbers?],[CustodyFieldName]))>0))
InStr([Custody Numbers?],[CustodyFieldName]))>0))
- Status
Similar threads
- Question
- Locked
- Question
- Locked
- Question