English 中文(简体)
在MS Access中,如何按记录数量分组报告。
原标题:in ms access, how to group reports by record count
  • 时间:2010-02-04 10:25:29
  •  标签:
  • ms-access

我想创建一个报告来打印特定的开始和结束日期的发票。 然而,我只想每页打印一定数量的记录。 即每页15个记录。 接下来的15(第16个到第30个)将进入下一页。 此外,需要每页的总金额。 我怎么做? 原因是我已经有了预打印的账单表格,只有15个条目。 无法通过排序和分组来解决问题。

谢谢任何帮助

问题回答

如果这些记录具有固定高度,如预印表格所示,则应检查“可缩小”和“可增长”属性是否设置为“否”,如果它们具有可变高度,则可以使用计数器并设置分页符的可见性,如本文所述:http://support.microsoft.com/kb/209006/en-us

至于总数,Allen Browne在页面总数方面有以下建议:http://allenbrowne.com/ser-11.html





相关问题
Handling no results for docmd.applyfilter

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 ...

access query to filter and combine count

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 ...

How to show File Picker dialog in Access 2007?

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 ...

MS Access: list macro from VBA

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 ...

Returning row number on MS Access

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 ...

热门标签