F
fossy
Ok, I have a table “tblEmployeesâ€, with employees training data. Out of this
table I created some queries: by training date, by employee manager, by
training type, by employee title…etc.
The query BY DATE it was pretty easy simple, as the criteria takes care of
it. When it was BY MANAGER, there are only 3 managers, so I made 3 queries
(one for each name). When I jumped to make the queries BY TYPE is when I had
problems… we have about 20+ training types, so I don’t really want to create
20 different queries.
I made a form with buttons (macros) to open the queries, and when it came to
the query BY TYPE, I placed a combo box with a list of the training types.
I want the user to select the training type from the combo box and then
click the button to place that “training type†as a parameter of the criteria
on the query. On that way, there is only one query with a open parameter as a
criteria.
Is this possible to achieve? Or do I have to make a query for each criteria?
I asked help with this and i got some answers before, but i just can't make
it work help please.
table I created some queries: by training date, by employee manager, by
training type, by employee title…etc.
The query BY DATE it was pretty easy simple, as the criteria takes care of
it. When it was BY MANAGER, there are only 3 managers, so I made 3 queries
(one for each name). When I jumped to make the queries BY TYPE is when I had
problems… we have about 20+ training types, so I don’t really want to create
20 different queries.
I made a form with buttons (macros) to open the queries, and when it came to
the query BY TYPE, I placed a combo box with a list of the training types.
I want the user to select the training type from the combo box and then
click the button to place that “training type†as a parameter of the criteria
on the query. On that way, there is only one query with a open parameter as a
criteria.
Is this possible to achieve? Or do I have to make a query for each criteria?
I asked help with this and i got some answers before, but i just can't make
it work help please.