Only one record appears instead of all!!! :(

[Only1Abhi]

Hi
I can't solve this problem (have tried anything possible) and failed... Below is my DB and also a picture showing EXACTLY what I want.

Here's my problem.

In the table tblCustomer, the customer has made 2 transactions with her 2 contacts (recievers). But when I try to put ALL this information in the report (Letter) it doesn't work.

It only shows the 1st contact and the 1st transaction.

What about the rest? That's what my problem is!

I want to be able to view ALL contacts (recievers) and ALL transactions made.

Enter the customer ID 253943694 when promopted.

Many many thanks...
Best Regards,
Abhi

My DB

http://www.access-programmers.co.uk...83f9d81ade3f2193e06371cc5f698b5&postid=158911

Picture explaining what I need

http://www.access-programmers.co.uk...83f9d81ade3f2193e06371cc5f698b5&postid=159366

The heading "Recievers" and all the customer contacts to go after this heading.

AND ONLY THEN (AFTER THE LAST CUSTOMER CONTACT of the Customer) I want the heading "Transactions".

Then I want all the transactions. That's all I want!!!

 

[Trendsetter]

I.ve sorted your problem and now need your email address to send the DB back to you

 

[Only1Abhi]

abhishek919@hotmail.com

Thank you very very much!

 

[Only1Abhi]

could u also post here telling me that you have sent the e-mail. Thank u very much again!!!

Really appreciate it.

Best Regards,
Abhi
:0)

 

[Trendsetter]

I have emailed to you for your examination hope this is what you were after

 

[Only1Abhi]

THANK YOU VERY MUCH.

Exactly what I was looking for!!!

Could u plz tell me, how did u get the two different headers? (headers for tblCustomer.CustomerID and CustomerContactID)???

Many many thanks Frank.
Best Regards,
Abhi
)

 

[Only1Abhi]

Can u also plz tell me what changes you made in the query?

(I can see the changes but don't understand how it affects the report).

Many thanks
Abhi
)

 

[Only1Abhi]

plz don't bother answering my first question (2nd to last post excluding this)!!!

 

[Trendsetter]

In the header of the report design page is a tab called "Sorting & Grouping" next to the Hammer & Spanner.
When you open this form you can select items to sort on and in the footer of the form is a property sheet that allows you to enter Headers & Footers and to format how they work.
I have set both Cust & Contact as havinf their own headers.
In the Query I have moved the relationship from Cust to Contact & Cust to Transaction

it now goes Cust to Transaction and Contact to Transaction

Prior to changing the relationship each contact would be shown with the total number of transactions in the tables - the query could not differentiate between contacts and listed them all with all transactions.

 

[Only1Abhi]

thank u very much Frank

Great Help.
Best Regards,
Abhi
)