snlodge
New member
- Local time
- Yesterday, 17:46
- Joined
- Jul 3, 2014
- Messages
- 9
I'm looking for assistance in understanding how to make a standardized four row (record), per page, Access report, even if there is only one(1) or two(2) record(s) related to each grouping. Essentially, if there is one(1) record, the query would add the required blank rows, to total four rows on the page and would do this for each additional grouping until there are no more records.
Plausible situation: Let's say that I had to inspect something once a week and the report was for a month (4 weeks) based on the inspected item. If my inspected item changed in the month, then the first inspected item would have so many records (inspections), and the second inspected item would have so many records (inspections). My need is that the first inspected item be detailed and the remaining weeks not inspected be added as blanks to the report, and the second inspected item follow the same outcome. This example would total 2 pages with four(4) rows each page, and a total of eight(8) rows combined.
Currently, some of the pages show only one week and we all know there are 4 business weeks to a month. Each week is one record, in this report.
Plausible situation: Let's say that I had to inspect something once a week and the report was for a month (4 weeks) based on the inspected item. If my inspected item changed in the month, then the first inspected item would have so many records (inspections), and the second inspected item would have so many records (inspections). My need is that the first inspected item be detailed and the remaining weeks not inspected be added as blanks to the report, and the second inspected item follow the same outcome. This example would total 2 pages with four(4) rows each page, and a total of eight(8) rows combined.
Currently, some of the pages show only one week and we all know there are 4 business weeks to a month. Each week is one record, in this report.