Expert: Richard Rost - 7/8/2009

Question
Hi. I am creating a report based on 1 table (RTL). The fields being used from the table in the report include: RTL MONTH, DEPARTMENT, NEW/RENEW, ESTEEM/NON-ESTEEM, UNDER, OVER. I have grouped DEPARTMENT so that all data for the same department is on one page. I have then grouped by NEW/RENEW, ESTEEM/NON-ESTEEM together (=[NEW-RENEW] & " " & "-" & " " & [ESTEEM/NON-ESTEEM]). So far the report is displaying as it should. In the details section of the report, I want to show UNDER and OVER by MONTH. UNDER and OVER in rows and MONTH in columns. The only way I have been able to get the correct data to be displayed is by creating the following IIF statements:

=IIf([MONTH]="Jan",[Under])
=IIf([MONTH]="Feb",[Under])
etc....

I've used unbound labels for the months going across the top and for "under" and "over" down the side. I get the correct data (for the 5 months I've enetered), except the data is diplaying stagnated. The "under" label appears 5 times and each value for the corresponding month displays under the month but in the next line down. Basically 1 row per month. How do I get them all to "squish" together in 1 line?

I'd REALLY appreciate your help with this!

Thanks,
Lynn

Answer
What does your TABLE DATA look like (show me a few records)?

What do you want the REPORT to look like (make me a sample)?

Let me know if you have any other questions or comments.

Also, be sure to visit my web site and watch my FREE 90-minute MICROSOFT ACCESS VIDEO TUTORIAL. Go to http://www.599cd.com/Access/AllExperts


Cordially,

Richard Rost
599CD Computer Training
http://www.599cd.com

P.S. Also, don't forget to visit my FREE Microsoft Access Tips & Tricks Page at http://www.599cd.com/Tips/AllExperts

P.P.S. I volunteer my time at AllExperts to help people, and I get a LOT of questions, so I can't take an hour to answer each question. If you need more DETAILED HELP, come to my TechHelp web site at http://www.599cd.com/TechHelp/AllExperts and I'll take as much time as you need to answer your question.

http://www.599cd.com/Microsoft_Access_Tutorial?key=AllExperts

Out of work? Know someone who is? Get a FREE copy of my Computer Job Skills CD at http://www.599cd.com/JobSkills?key=AllExperts