How to add blank lines to complete an Access report so that it matches a printed form? -
i deal bunch of government forms, , find myself trying access 2013 output report matches pre-printed form.
most of forms in .pdf form, access doesn't handle them (to knowledge) without additional software, cannot install on user production computers.
so re-create form access report, have real difficulty when have enough records half page.
how report print required records, , fill page blank records "form" looks correct?
i'd willing try possible solution - i've gone far create blank records try make work. goal, however, automate process user can generate report , prints out correctly without bunch of fiddling.
on form, or of lines might used, , each person (i have ~550 people each have individual form) has different number of lines, depending on number of jumps have completed.
i have dummy table single numeric field called id
. populate number of records greater biggest number of 'extra' records you're ever going need fill form, using numbers 1 upwards id
. original record source query report is:
select field1, field2, field3, field4 mytable order field1
and want 15 rows fill form, change report's record source to:
select top 15 sort_seq, field1, field2, field3, field4 ( select 0 sort_seq, field1, field2, field3, field4 mytable union select id, null, null, null, null dummytable ) x order sort_seq, field1
Comments
Post a Comment