query data

[jefferysf via AccessMonster.com]

Hi. I am building an aviation database. I am want to create a flight
summary query that shows only
Carrier
Date of Flight
Origin
Destination
Miles
Flight Hours

However, my result is a line for each passenger - for example If there were
three passengers on one flight i am getting 3 lines with 3 x the miles and 3
x the hours. How do I return only one line per flight.

Also, I want to be able to show flight details with all passenger names for
each flight. Is a subreport the answer there?

Thanks,
JF

 

[Smartin]

Hi. I am building an aviation database. I am want to create a flight
summary query that shows only
Carrier
Date of Flight
Origin
Destination
Miles
Flight Hours

However, my result is a line for each passenger - for example If there were
three passengers on one flight i am getting 3 lines with 3 x the miles and 3
x the hours. How do I return only one line per flight.

Also, I want to be able to show flight details with all passenger names for
each flight. Is a subreport the answer there?

Thanks,
JF

Hello,

Do you perchance have all your data (passengers & flights) in one table?
If so, this is making your life more difficult. For a quick fix, you
could modify your query to return DISTINCT results by opening the query
properties and changing the "unique values" property to Yes.

For your second question, and again assuming all the data is in one
table, I think you could just add passenger fields to the query you posted.

If you /do/ have your data organized as I surmise, you will probably
encounter more conundrums because your data is not "normalized". There
is much discussion here and on the web regarding "relational database
design" and "normal form", but feel free to ask if you need assistance
regarding the whys and wherefores of this concept.

Hoping this helps!