Joined: 24 Dec 2013
Online Status: Offline
Posts: 4
Topic: Kinda like Mail labels but not. Posted: 27 Dec 2013 at 10:34am
I'm creating a report with specific Criteria. 1. It will be on an 8 1/2 x 11. 2. Each employee will have employee name, spouse, addresses 1 and 2, C/S/Z and two Phone numbers. Totaling 6 line per employee. 3. Owner's name will appear on the top two columns with different addresses. 4. After that the employees in alphabetical order. 5. 2 roles with 7 employees per page. 6. The report uses only one table.
It looks like mailing labels but it is just a listing of employees.
I have taken the label wizard and got close to those spec's, but not the seven employees per page. I have just 6. Maybe a little more tweaking. Then some questions arise;
How can I extract the owners name from the list and place them at the top and then start printing the other employees? Then suppress him later.
Should I create a sub-report with the rest of the employees. But how do I make it look like mailing labels?
Right now this list is run on an excel spread sheet with tons of macros to achieve the report. I would appreciate any help at all. Please. Mark
Joined: 05 Sep 2012
Location: United States
Online Status: Offline
Posts: 177
Posted: 31 Dec 2013 at 4:27am
Try using cross tabs. They are tricky but I was able to get something similar to this.
create your field that will have your emp info and put that for your columns and you can create a field for the owner and have that as the header maybe.
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot delete your posts in this forum You cannot edit your posts in this forum You cannot create polls in this forum You cannot vote in polls in this forum