My Report is not showing all of my Detail

[skin76]

I'm trying to build a report that has 4 details which numbers records will have to show for each detail, for example
Detail
All Passengers
Customer Payments
Supplier Payments
Additional Charges Misc Fees

When I try to build the report all of detail for the record will not show or it's showing duplicate infor. I have tried grouping for each group but it who duplicate data. What is the best way to do this. Do I need to build separate queries?

Thanks in Advance

 

[dhookom]

It is impossible to tell how all of these are related. I suggest you use subreports for most all related tables that are on the "many" side.

Duane
MS Access MVP
Find out how to get great answers faq219-2884.