First off, thanks for your time. I'm somewhat savvy to technology - not so much in making db's - but I haven't been able to identify how to get around this issue. I'll do my best to explain it succinctly:
I have a personal db that I use for managing a rather large music database, including the following fields (all text fields):
Group_Name
Album_Name
Year_Released
Genre
The report is grouped by Genre. Sort order is Group_Name, Year_Released, and Album_Name.
Q: if an artist has enough records that it is necessary to span pages in the report, how do I have both the Genre and the artist display at the top of the new page?
Example: The Rolling Stones have so many albums that the records span three pages. How do I go about making the Genre and Group_Name appear at the top of the page for each report page including their data?
Thanks again for your time; it is much appreciated!
I have a personal db that I use for managing a rather large music database, including the following fields (all text fields):
Group_Name
Album_Name
Year_Released
Genre
The report is grouped by Genre. Sort order is Group_Name, Year_Released, and Album_Name.
Q: if an artist has enough records that it is necessary to span pages in the report, how do I have both the Genre and the artist display at the top of the new page?
Example: The Rolling Stones have so many albums that the records span three pages. How do I go about making the Genre and Group_Name appear at the top of the page for each report page including their data?
Thanks again for your time; it is much appreciated!