Hi All,
I'm new to this forum and new to Access databases.
I know I should read many tutorials or books to get the hang of it but I just don't have time.
I am in charge (why it is me is a long explanation) for creating a database for the local retirement home. They organize many trips and want to keep track of everything in database.
So I created a database with all the people in the retirement home. Then I want a form to create a new trip. I want that form just to give me listboxes of the table so I can select the people that go on the trip. After I select them (and I have to be able to do it on multiple days because not all people will tell the same day that they will go on the trip) I have to be able to save those selections in a new table (name of the table should be chosen at time of saving) and so on with many trips during the year (and thus multiple tables for multiple trips. I want it to be very easy so the people who work at the retirement home just have to select the people and click on a button to save that selection in a new table and in the new table are the data from the Original table.
At the end of the year I should be able to generate a table or query so I can see which people went on which trip and the totals.
Is there allready some sort of database with this function I can use or change to be able to do what I have to do. Many thanks.