AboutRichard Rost Expertise I am happy to answer any kinds of questions about Microsoft Access - from basic table design to advanced VBA programming. Also, please feel free to check the Access Tips & Tricks section of my web site.
Education/Credentials I am a self-taught Access expert. I have been building databases for clients since the early 90s. You can see a sample of my Access Tutorials on my web site at 599CD.com
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:
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.
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.
