插入空白记录以查询标签打印结果 [英] Inserting blank records to query result for label printing

问题描述

怎么做，


我有一个表格，可以输出格式，可以打印到3x7标签纸上用于信封。


我想要的是一种在查询结果中输入空白（或）行的方法，其中用户指定在该特定位置没有打印标签。


I我知道向表中插入空白记录的问题。我说这是我搜索过的其他论坛所有回复都是怀疑和谴责将空白行插入数据库而不是提出对问题的支持。


我不想存储空白行，只需按用户指定的时间间隔将它们插入报告的记录源。


例如，行填充标签：


第1行|第2行|第3行

第4行|第5行|第6行


等


如果空间中没有标签，将打印第3行，我希望能够输出行如：


第1行|第2行| BLANK

第3行|第4行|第5行


等


无论如何都要在正确的位置添加空白记录而不需要创建记录集逐行？


非常感谢，


NDayave

How do,

I have a form that outputs addresses in a format that can be printed on to 3x7 label paper for envelopes.

What I want is a way to enter blank (or " ") rows to the query result where the user specifies so no label is printed in that particular place.

I am aware of the problems of inserting blank records to tables. I say this as the other forums I have searched all reply with disbelief and condemnation for inserting blank rows into a database rather than offering support to the question asked.

I am not trying to store the blank rows, just insert them into the Report''s record source at user specified intervals.


For example, the rows populate the labels as such:

Row 1 | Row 2 | Row 3
Row 4 | Row 5 | Row 6

etc

If there is no label in the space Row 3 would be printed on, I want to be able to output the rows as:

Row 1 | Row 2 | BLANK
Row 3 | Row 4 | Row 5

etc


Is there anyway of adding the blank record in at the correct place without resorting to creating a recordset line by line?

Many Thanks,


NDayave

推荐答案

是。


您可以在查询中创造性并在查询背面构建标签报告。


我不喜欢我们认为我们现在有足够的详细信息可以进一步发展，但它可能会涉及到足够多的项目表来填充整页。我会停在那里，因为当我得到详细信息时我不想回溯。

Yes.

You can be creative in a query and build the labels report on the back of the query.

I don''t think we have enough detailed info here to go much further for now, but it will probably involve a table of enough items to populate a full page at least. I''ll stop there as I don''t want to have to back-track when I get the details.

基本上，我有一个邮件列表生成器，它生成一个地址列表根据所选标准。


即：姓，姓，地址1，地址2等等


查询是通过VBA代码生成的基于用户做出的选择。由于涉及个人联系人和组织，因此可能会使用联盟，但并非总是如此。


为什么需要一整页的标签？我问，因为他们可能只在一次打印中打印几个标签，但在另一个打印中打印几页。



您要使用哪种信息？

Basically, I have a mailing list generator that produces a list of addresses based on the criteria selected.

Ie: Forename, Surname, Address1, Address2, etc, etc

The query is generated via VBA code based on the selections made by the user. As this involves both Individual Contacts and Organisations, there is the possibility of a Union being used, but not always.

Why would it require a full page worth of labels? I ask as they may only print a couple of labels in one sitting, but several pages in another.


What sort of information are you after?

< br>

NDayave ：为什么需要一整页的标签？我问，因为他们可能只在一次打印中打印几个标签，而在另一个打印中打印几页。

NDayave: Why would it require a full page worth of labels? I ask as they may only print a couple of labels in one sitting, but several pages in another.

我正在考虑一个驱动数据源，可用于将主数据链接到。这可能不是很清楚，所以我将尝试澄清：


驱动数据源是您使用LEFT或RIGHT JOIN加入另一个源的驱动数据源（参见 SQL JOIN 以获取更多详细信息）。现在我将继续使用LEFT JOIN概念，因为这似乎更容易理解。如果您想在任何地方使用空白记录，您使用的数据源必须能够识别该项目，并且将设置它以便不从主数据中找到匹配的记录。没有详细说明如何识别物品（可以使用哪些索引）我无法详细了解。

I was thinking along the lines of a driving data source, that could be used to link your main data to. This may not be very clear so I will try to clarify :

A driving data source is one that you JOIN another source to, using either a LEFT or RIGHT JOIN (See SQL JOINs for more details of this). For now I will continue using the LEFT JOIN concept as that seems simpler to understand. If you want a blank record anywhere, the data source you use must be able to identify that item, and it would be set up so as not to find a matching record from your main data. With no details of how the items are identified (what indexes may be used) I''m not in a position to get into details.

NDayave ：你之后有什么样的信息？

NDayave: What sort of information are you after?

对用户确定等术语有一些更详细的理解。它本身根本不提供任何信息。如果您可以解释用户如何指定这个以及决定所选项目的内容，那么我们就可以构建一些内容。


有时候如果没有上下文的话，人们无法确定需要什么数据。题。这就是为什么主要由你来包括所需要的东西。我可以指出可能需要的项目，但是其他信息在提供时可能会产生一些多余的信息。


使用您的示例，其中记录＃3应为空白，您需要考虑你所拥有的可以识别记录＃3是空白的。但是所有其他人都匹配。无论您是通过表（在某处创建空白记录）还是在LEFT JOIN查询中执行此操作，都是如此。

Some more detailed understanding of terms like user determined. On its own it provides no information at all. If you can explain how a user specifies this and what determines a selected item, then we have something we can build on.

Sometimes one cannot tell what data is required without the context of the question. That is why it is mainly down to you to include what is required. I can point to items that may be necessary, but other information, when supplied, may make some of that superfluous.

Using your example where record #3 should be blank, you need to consider what you have that could identify that record #3 is blank. but that all others match. This is true whether you do this via a table (creating blank records somewhere) or do it in a LEFT JOIN query.

这篇关于插入空白记录以查询标签打印结果的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！