TomJamieson
Registered User.
- Local time
- Today, 19:22
- Joined
- Jun 8, 2006
- Messages
- 50
Apologies if this has been covered lots before, I searched and couldn't find anything. I am very new to this side of Access so simple instructions would be appreciated. I'll try to explain it as clearly as I can also.
I have a table with a bunch of fields detailing a job going through our factory.
There are hundreds of these records, so the user must be able to search to view only the ones they want to see.
So I created a form with some combo boxes/text boxes, each labelled for a different field, so they can choose PO number, customer name, supplier name, out date OR job status, and view all the records with a certain criteria attatched to one of those fields.
Problem is, I want them to be able to search for all jobs from a certain supplier AND a certain outdate. Or any combination of those 5 fields, maybe filling in all of them, or 4 or 3 or 2 or just 1. At the moment they can search by one of them, then press the button, and I have a different query for each one.
Have I explained that well enough? Please ask if I need to make something clearer. Hope somebody can help.
I have a table with a bunch of fields detailing a job going through our factory.
There are hundreds of these records, so the user must be able to search to view only the ones they want to see.
So I created a form with some combo boxes/text boxes, each labelled for a different field, so they can choose PO number, customer name, supplier name, out date OR job status, and view all the records with a certain criteria attatched to one of those fields.
Problem is, I want them to be able to search for all jobs from a certain supplier AND a certain outdate. Or any combination of those 5 fields, maybe filling in all of them, or 4 or 3 or 2 or just 1. At the moment they can search by one of them, then press the button, and I have a different query for each one.
Have I explained that well enough? Please ask if I need to make something clearer. Hope somebody can help.
