Search results

Is there a way to get the results from a multiple table query into a report? I have Staff_First_name, Staff_last_name, Staff_email and Staff_tele_no from my Staff table. I then have Event_trip_title and departure_date from my Trip table. My multiple table query shows a member of staff and the...

I have the tables tbl_staff and tbl_trip. I want a select query which lists staff members and shows all the trips they have managed (been group leader of.) In the trip table, the group leader is stored in Group_Leader_ID, which corresponds with Staff_ID. The fields I want to be output is the...

Hi everyone, I was hoping I could get some help I am making a database to organise trips. I have a trip form, where the user can add the overall details of the trip. This includes selecting an Organising Company, an Insurance Company, and an Accommodation through the use of combo boxes. When...