Hello all,
I am new to Access and reading and trying as many things as I can find because i love it.
I have at table that has Trips and Departures in it. The second table I have has Guest Information in it. They are linked together by the Trip and Departure. Each trips has 4 Sub Trips (A, B, C, D) and each guest is on one of those Sub Trips.
I have created a query that counts the total number of guests on each sub trip by a specific trip an departure. For example, Trip (Hawaii) Departure (2) has 8 guests on part A, 10 guests on part B, 4 guests on part C and 5 guests on part D.
Now I need to put those total back in the Trip Departure Table, so how do I update that table from the query?
Hope that makes sense,
Matt