将记录多次复制到表中 [英] Copying record to a table several times
问题描述
嗨
我相信有一种简单的方法可以做到这一点,但我已经筋疲力尽了。
我在表格中有一些标签数据我想复制到一个相同的表。但是,第一个标签我可能只想将其中一个标签数据复制到新表中。第二个标签我可能希望将七个标签数据复制到新表中。我有一个名为nooflabels的计数字段!第一个记录中有1个,第二个记录中有7个。
我创建了一个追加查询并设置了一个宏来运行然后在我的表单中创建了一个按钮来运行该宏
Hi
I am sure there is an easy way to do this but I have exhausted all avenues.
I have some label data in a table which I want to copy to an identical table. However the first label I may only want one of that label data copying to the new table. The second label I may want seven of that label data copying to the new table. I have a count field called "nooflabels"! which has 1 in the first record and 7 in the second.
I have created an append query and set up a macro to run then created a button in my form to run that macro
推荐答案
您好,jacc14。
通常通过记录集迭代在VBA中完成。我相信你会收到很多关于它如何完成的建议。
所以我建议你使用纯SQL解决方案。只是为了说明这种方法的可行性。见附件。
问候,
鱼
Hi, jacc14.
It is normally done in VBA via recordset iteration. I''m sure you will receive numerous advices of how it could be done.
So I would suggest you pure SQL solution. Just to show feasibility of this approach. See attachment.
Regards,
Fish
亲爱的FishVal
这很棒。我申请了,它有效。
谢谢
Jacc14
Dear FishVal
This is excellent. I have applied and it works a treat.
Thank you
Jacc14
亲爱的FishVal
我希望你不介意我把这个问题告诉自己,但你已经知道我要去哪里了,我又要挣扎了
我现在制作的表格看起来像这样。
Dear FishVal
I hope you dont mind me directing this question to yourself but you already know where I am going with this and I am struggling again
The table which I have now produced looks like this.
这篇关于将记录多次复制到表中的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!