Hi,
I think I am trying to do excel in Access. Basically, the report I am trying to create has a group and then several names below that with many columns of data amounting to about 4 pages per group (in excel). I am trying to automate this in Access doing the same exact thing but the dot grid (report/design/property sheet/Format/grid x) will only allow me to expand to 64 and I need more room. Is there a different way I could approach this so that I could keep the four pages together by Group?
Here is how I want it to look design wise with the asterisks being the page breaks:
Group A
Name Data 1 Data 2 Data 3 Data 4 Data 5 * Name Data 6 Data 7 Data 8 Data 9 Data 10 * Name Data 11 Data 12 Data 13 Data 15 * Name Data 16 Data 17 Data 18 Data 19 Data 20
Person 1 * Person 1 * Person 1 * Person 1
Person 2 * Person 2 * Person 2 * Person 2
Person 3 * Person 3 * Person 3 * Person 3
Total * Total * Total * Total
THANK YOU!!!