在同一报表中打印记录的多个副本 [英] Printing multiple copies of a record in the same report

问题描述

您好，我正在使用Access 2003来创建库存数据库。在我的数据库中，我有一个事务表，用于记录交易日期#Receved for Item＃的交易。我想创建一个报告，打印出每天输入的库存的价格标签。我知道我可以创建一个队列来查找在特定日期有交易的项目，但每个项目只在我的数据库中列出一次。我想要做的是让Access重复每个细节我在#recieved列中输入的次数。


示例：10月9日我收到了6件毛衣＃456;我以25美元卖掉它们;

2件T恤＃1123 10美元;

和1件背心＃753，现价$ 15。


当我打印10/9的价格贴纸时，我想用＃456 $ 25的价格贴纸
6;

2，＃1123 $ 10;

和1＃753 $ 15。

来自相同的价格贴纸报告。


这可能吗？任何建议都将不胜感激。

解决方案

25;

2件T恤＃1123 for

10;

和1背心＃753 for

15。


当我打印10/9的价格贴纸时，我想用＃456

的

价格贴纸>

Hi, I am using Access 2003 to create an inventory database. Within my database I have a table for transactions that records the # recieved for an Item # by the transaction date. I would like to create a report that would print out price stickers for the inventory entered on each day. I know I can create a queary to find the items that have transactions on a certain date but each item is only listed once in my database. What I would like to do is have Access repeat each detail the number of times that I have entered in the # recieved column.

Example: On 10/9 I recieved 6 Sweaters item #456; I''m sellling them for $25;
2 T-Shirts #1123 for $10;
and 1 Vest # 753 for $15.

When I print the price stickers for 10/9 I would like
6 price stickers with #456 $25;
2 with #1123 $10;
and 1 with #753 $15.
from the same Price Sticker Report.

Is this possible? Any Advice would be appreciated.

解决方案

25;
2 T-Shirts #1123 for

10;
and 1 Vest # 753 for

15.

When I print the price stickers for 10/9 I would like
6 price stickers with #456

这篇关于在同一报表中打印记录的多个副本的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！