Hi All,

I have attached my passenger database (work in progress). I am trying to total the number of passengers of each gender sitting in each zone, for each sector. The attached DB is pretty self explanatory.

Could I have some help please, as It's not adding correctly and I have obviously overlooked something.

Thank you

Manifest.zip

You have passenger records containing: Zone, Seat, Gender etc.

Duplicate passenger record table for Zone, Seat , Gender etc.

Make necessary relationships to detect Zone, Seat, Gender etc. - each of these tables reflect records in Zone or Seat or Gender and so on.

Use "Count" to find out records in Table Zone and so on.

And for overall use "sum".

But I cannot see idea :qwery: "what must be self-explanation" on file as you say

I hope - this can help.

Thanks for the reply Peter,

My end goal is a manifest, with passengers assigned to a sector, which is assigned to a flight. Each sector has a summary showing how many people of each gender in each zone (there are 3, A, B, C) of the aircraft. This is based on their seat number which grabs the zone from the zones table. It combines this with their gender to create MA (Male, Zone A). I then add these up for each sector.