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.

da form 1307

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

Popular posts from this blog

php - Permission denied. Laravel linux server -

google bigquery - Delta between query execution time and Java query call to finish -

python - Pandas two dataframes multiplication? -