Text box in header

[Ray67]

Hello

I have a report builded. Just missing to put one field. When i put the field in detail section it display the data. When i put the same field in report header it doesn't display the data. What i'm i doing wrong????

Thank you

[June7]

Would have to analyse db if you want to provide.

[Ray67]

720 - Copy2.mdb


Thank you

[June7]

It's because the textbox in report header shows Year value from first record in the report RecordSource. The Year field is blank for that record. It is the record with only the 0.00 in the Total field. Do you need that record? If not, change Q_RentByMonth2 from RIGHT to LEFT JOIN.

TRANSFORM Sum(Q_RentByMonth.DepositAmount) AS SumOfDepositAmount
SELECT Q_RentByMonth.Month, Q_RentByMonth.MonthNumber, Q_RentByMonth.Year
FROM Q_RentByMonth LEFT JOIN T_Description ON Q_RentByMonth.Description = T_Description.DescriptionID
GROUP BY Q_RentByMonth.Month, Q_RentByMonth.MonthNumber, Q_RentByMonth.Year
ORDER BY Q_RentByMonth.MonthNumber
PIVOT T_Description.Description;

[Ray67]

June7

I try the SQl you suggested. It's not showing all description that i would like to show. Rent Apt#6 is not showing. I would like to show all rent description even if there isn't any payments collected.


Thank you

[Ray67]

June 7

I got it. This is what i did open the crosstab query in design view;
right click in the area near the tables; and select Properties. Next go into
the Column Headings and put in something like: 'Rent Apt# 1','Rent Apt# 2','Rent Apt# 3','Rent Apt# 4','Rent Apt# 5','Rent Apt# 6'

Thank you for all your help.