I am building a personnel directory for a large school district. The booklet produced show names, addresses etc. and is sorted alphabetically within buildings but there are 8 different buildings. The whole booklet is about 30 pages long.
What I want to do is print another report to include with the booklet that is an alphabetic list by name which lists the page the employee detail is found on. Without such a list, someone might have to search all 8 buildings to find the employee. I suppose I could print a list of names with buildings, but going to a specific page would be faster.
I have a field for "Page number" for each employee, but I won't know the page until AFTER the directory is prepared and even then I don't know how to include the page number into the field for the employee.
I guess my question comes down to this: How do you include the page number on a report into a table for the records that make up the report.
I posted here, because I don't know if this is a "Report" or "Query" inquiry.
What I want to do is print another report to include with the booklet that is an alphabetic list by name which lists the page the employee detail is found on. Without such a list, someone might have to search all 8 buildings to find the employee. I suppose I could print a list of names with buildings, but going to a specific page would be faster.
I have a field for "Page number" for each employee, but I won't know the page until AFTER the directory is prepared and even then I don't know how to include the page number into the field for the employee.
I guess my question comes down to this: How do you include the page number on a report into a table for the records that make up the report.
I posted here, because I don't know if this is a "Report" or "Query" inquiry.
