我想创建一个报告来打印特定的开始和结束日期的发票。 然而,我只想每页打印一定数量的记录。 即每页15个记录。 接下来的15(第16个到第30个)将进入下一页。 此外,需要每页的总金额。 我怎么做? 原因是我已经有了预打印的账单表格,只有15个条目。 无法通过排序和分组来解决问题。
谢谢任何帮助
我想创建一个报告来打印特定的开始和结束日期的发票。 然而,我只想每页打印一定数量的记录。 即每页15个记录。 接下来的15(第16个到第30个)将进入下一页。 此外,需要每页的总金额。 我怎么做? 原因是我已经有了预打印的账单表格,只有15个条目。 无法通过排序和分组来解决问题。
谢谢任何帮助
如果这些记录具有固定高度,如预印表格所示,则应检查“可缩小”和“可增长”属性是否设置为“否”,如果它们具有可变高度,则可以使用计数器并设置分页符的可见性,如本文所述:http://support.microsoft.com/kb/209006/en-us。
至于总数,Allen Browne在页面总数方面有以下建议:http://allenbrowne.com/ser-11.html。
I am copying a record from one table to another in Access 2007. I iterate through each field in the current record and copy that value to the new table. It works fine until I get to my lookup column ...
In C#, I know that I can overload the constructor for a class by specifying it in the body of the class: public class MyClass() { public MyClass(String s) { ... } } This overrides the default ...
I have an Access app where I use search functionality. I have a TextBox and a Search Button on the form, and it does a wildcard search of whatever the user enters in the TextBox, and displays the ...
i have two access tables tableA num count 1 7 2 8 3 9 4 9 5 13 6 6 tableB num count 0 1 1 14 2 12 3 5 4 5 5 11 6 5 how can i create an access query that ...
I want to show a dialog where the user can pick a file, click OK, and then the path to the file will be saved in the database. I have just one problem, I can t figure out how tho show the dialog ...
On a continouos form in ms-access, I have a record source similar to select col_1, col_2 & " " & col_3 as col_expr from tblFoo and then I have bound col_expr to a text box on that form....
I have to deal with a few macros (not VBA) in an inherited Access application. In order to document them, I would like to print or list the actions in those macros, but I am very dissatisfied by ...
I have 4 tables, from which i select data with help of joins in select query...I want a serial no.(row number) per record as they are fetched. first fetched record should be 1, next 2 and so on... In ...