Hi, I have created a database to track the lot numbers of products associated with a particular customer invoice. The invoice number is barcoded on the invoice and scanned into the database. All of the lot numbers associated with products on that invoice are also scanned into the same record. Each record contains a field for the invoice number and multiple fields for the lot code numbers. How can I filter all of the records that might contain a particular lot number I am looking for?
Filter records
- Thread starter Daryl88
- Start date
ted.martin
Registered User.
- Local time
- Today, 19:16
- Joined
- Sep 24, 2004
- Messages
- 743
Given you are in the Query section, this is the essence of using a filter CRITERIA in the query.
Too much info for here but these links may help:
http://office.microsoft.com/en-us/access-help/examples-of-query-criteria-HA010066611.aspx
www.fontstuff.com/access/acctut06.htm
Too much info for here but these links may help:
http://office.microsoft.com/en-us/access-help/examples-of-query-criteria-HA010066611.aspx
www.fontstuff.com/access/acctut06.htm
