添加空记录 [英] Adding empty records
问题描述
我之前提出了一个类似的问题，在2006年回复了一个问题。我试图使用所提供的信息但无法使其发挥作用。
我创建了一个数据库来打印一份与原始手写表格相同的报告。我在这个报告中遇到的问题是打印最后一条记录时没有更多的额外行（即如果文档有15行要填写，如果我打印
来自访问时只输入10条记录，我得到10条线。）。
我想用空记录完成额外的行（前一个例子中有5条记录）有很多次我们需要在打印后手工添加信息，我们需要这些线。
这里是我试图从以前使用的帖子。
A similar question to mine was asked before with one reply back in 2006. I tried to use the information provided but was unable to make it work.
I created a database to print out a report that is the same as the original hand written form. The problem I''m running into with this report is when the last record prints and there are no more additional lines (i.e. if the document has 15 lines to be filled out, and if I print
from Access with only 10 records entered, 10 lines is all I get.).
I''d like to complete the additional lines using empty records (5 records per the previous example) since there are many times we will need to add information to the report by hand after it has been printed and we will need the lines.
here is what I was attempting to use from a previous post.
推荐答案
使用union查询将空白记录追加到记录源。不需要乱码。
Use a union query to append blank records to the record source. No need to mess with code.
如果我没有遗漏某些东西，他们还需要将查询中返回的记录数限制为15.这可以使用SELECT子句的TOP谓词。这也可以通过设置最高值属性在 QueryDef 的属性中处理。
If I''m not missing something, they would also need to restrict the number of records returned in the query to 15. This can be done using the TOP predicate of the SELECT clause. This can also be handled in the properties of a QueryDef by setting the Top Values property.
实际上，虽然没有说明，但我相信目标是达到15的倍数。在这种情况下，创建一个数字为1到15的表，并使用mod返回你需要联合的空行数。
Actually, though not stated, I believe the goal is to reach a multiple of 15. In which case, create a table with the numbers 1 through 15 and use a mod to return the number of blank rows you need to union.
这篇关于添加空记录的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
