Search results

The error occured when it prompted me to choose which fields i want to be included on the report from the query. It let me choose fields from one table, but not both. But I think i've solved it - I tried a couple of things and found it is possible to choose one table's fields in the wizard...

I'm using the query. Is it possible or impossible? Because if it's impossible maybe that's why im coming up with the error. The query works fine, by the way.

I rephrased the question in hopes someone can help me :(

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...

That worked! thankyou! I think I understand the code a bit better now too :)

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...