Hi all..
I'm back again.. still working on the same database, and still pulling my hair out!
Hopefully your wealth of knowledge can help..As my knowledge of Access is limited to say the least but i am always learning
I have created a database to record training histories within our company. Basically it consists of multiple tables, containing employee info, class info etc.
All is working fine and i can successfully query the database and pull the relevant reports. However:
I have created a query which shows all training to date. (class id, Duration, trainer, attendees, start time, start date etc). i want to be able to use a form to select a/multiple specific fields and then perform a search on this query ..
eg.. I want to know what training happened in training room 1, on the 2nd of December. or i want to see what training a specifc trainer did on a specific date
Basically i want to be able to search the database using multiple fields
I was thinking of creating a form to populate a table containing the main fields that i would search under (the search variables).. I would then use this table in conjunction with the query showing all training to dislpay the results i need..
Hopefully someone can help.. Apologises if i have not explained this well but to summarise i think i need to be able to search the result of a query usng multiple fields on a form..
Thanks in advance for all your help
Noel
I'm back again.. still working on the same database, and still pulling my hair out!
Hopefully your wealth of knowledge can help..As my knowledge of Access is limited to say the least but i am always learning
I have created a database to record training histories within our company. Basically it consists of multiple tables, containing employee info, class info etc.
All is working fine and i can successfully query the database and pull the relevant reports. However:
I have created a query which shows all training to date. (class id, Duration, trainer, attendees, start time, start date etc). i want to be able to use a form to select a/multiple specific fields and then perform a search on this query ..
eg.. I want to know what training happened in training room 1, on the 2nd of December. or i want to see what training a specifc trainer did on a specific date
Basically i want to be able to search the database using multiple fields
I was thinking of creating a form to populate a table containing the main fields that i would search under (the search variables).. I would then use this table in conjunction with the query showing all training to dislpay the results i need..
Hopefully someone can help.. Apologises if i have not explained this well but to summarise i think i need to be able to search the result of a query usng multiple fields on a form..
Thanks in advance for all your help
Noel
