Morning...I need some help with my report in ms access 2007. I have 2 different issues:
1. I need to combine records in my report. For example I have 5 employees contact information but instead of having the company name listed only once with the names of all 5 employees listed under it, I have the company listed 5 times with only one employee beneath it. How do I put all names under one heading.
2. I need to be able to add in a simple restriction to allow information like the phone, fax, email, etc. to show only if there is information there.
Any help you can provide will be appreciated. Thanks!
Thanks for the reply. How do I do the grouping. I have been trying to do it but nothing happens when it is done.
For the phone, etc. I have the tag line that is displayed. The record itself stays blank if there is nothing there. So I need to get rid of the field header when nothing is there and have it displayed when there is. Thanks!
For your phone you will need code on the print format event to check if the field is null then set the field header visible property to FALSE if the field is not null then set the field header visible to TRUE.
Thanks. That is what I thought for the phone but I was trying to find a solution around that. So is there anyway to do the phone without using the code. The people who will be using the database don't know how to program and if they have to change anything in the future, this will make it more complicated and I will not be there to help.
I understand your point. But what I am asking is is there any way for me to hide the label of the field when it is empty without using a program to do it. I am using an if/else statement, but my client has no programming experience.
Using an IF.... ELSE... ENDIF should work. You just need a lit bit of IF ELSE END IF code. If you are still having trouble post your database with the relevant data table(s), queries and report etc. and I will have a look. Please for security purposes do not use actual data use test data for testing.
I was able to zip the database. Was trying to do a screen shot of the report and that wasn't working when it is zipped. As you will see when you go to the report view my field labels are showing there but not when it is printed. The print out looks fine. So, is it normal for the field labels to show on the report view.