怎么把Layout表里的每行在查询表里每行增加16行

yandaili123 · 发表于 2015-1-25 20:25:50

大家好：
麻烦大家把附件的问题给解决一下（怎么把Layout表里的每行在查询表里每行增加16行）

谢谢大家

access学习交流 · 发表于 2015-1-26 10:40:37

每行增加16行？
写个循环语句添加不就可以了吗？

zhidao · 发表于 2015-1-26 13:26:20

看看是不是你要的效果

yandaili123 · 发表于 2015-1-26 23:23:58

zhidao 发表于 2015-1-26 13:26
看看是不是你要的效果

能直接用查询做吗，如果不用窗体的话

yandaili123 · 发表于 2015-1-26 23:28:11

access学习交流发表于 2015-1-26 10:40
每行增加16行？
写个循环语句添加不就可以了吗？

在查询里可以直接做吗做吗，

roych · 发表于 2015-1-27 10:02:54

追加16次不就行了么？{:soso_e113:}
或者写一个联合16次的查询，再以这个为数据源进行追加（如果原先有表的话，生成表也行）。

select * from 表1
union all
select * from 表1
………………………
union all
select * from 表1
'union all部分共计15次。

复制代码

zhidao · 发表于 2015-1-27 10:59:00

yandaili123 发表于 2015-1-26 23:23
能直接用查询做吗，如果不用窗体的话

方法有很多，看你习惯用那一种，查询暂时还没怎么涉入，各有优缺点。不妨换个思路运用。

yandaili123 · 发表于 2015-1-27 23:53:42

roych 发表于 2015-1-27 10:02
追加16次不就行了么？
或者写一个联合16次的查询，再以这个为数据源进行追加（如果原先有表 ...

S01F-LB-13 CC-TAIX11 1 B01F-LB-01
S01F-LB-13 CC-TAIX11 1 B01F-LB-01
S01F-LB-13 CC-TAIX11 1 B01F-LB-01
S01F-LB-13 CC-TAIX11 1 B01F-LB-01
S01F-LB-13 CC-TAIX11 1 B01F-LB-01
S01F-LB-13 CC-TAIX11 1 B01F-LB-01
S01F-LB-13 CC-TAIX11 1 B01F-LB-01
S01F-LB-13 CC-TAIX11 1 B01F-LB-01
S01F-LB-13 CC-TAIX11 1 B01F-LB-01
S01F-LB-13 CC-TAIX11 1 B01F-LB-01
S01F-LB-13 CC-TAIX11 1 B01F-LB-01
S01F-LB-13 CC-TAIX11 1 B01F-LB-01
S01F-LB-13 CC-TAIX11 1 B01F-LB-01
S01F-LB-13 CC-TAIX11 1 B01F-LB-01
S01F-LB-13 CC-TAIX11 1 B01F-LB-01
S01F-LB-13 CC-TAIX11 1 B01F-LB-01
S01F-MB-01 CC-TAIX01 2 B01F-LB-03
S01F-MB-01 CC-TAIX01 2 B01F-LB-03
S01F-MB-01 CC-TAIX01 2 B01F-LB-03
S01F-MB-01 CC-TAIX01 2 B01F-LB-03
S01F-MB-01 CC-TAIX01 2 B01F-LB-03
S01F-MB-01 CC-TAIX01 2 B01F-LB-03
S01F-MB-01 CC-TAIX01 2 B01F-LB-03
S01F-MB-01 CC-TAIX01 2 B01F-LB-03
S01F-MB-01 CC-TAIX01 2 B01F-LB-03
S01F-MB-01 CC-TAIX01 2 B01F-LB-03
S01F-MB-01 CC-TAIX01 2 B01F-LB-03
S01F-MB-01 CC-TAIX01 2 B01F-LB-03
S01F-MB-01 CC-TAIX01 2 B01F-LB-03
S01F-MB-01 CC-TAIX01 2 B01F-LB-03
S01F-MB-01 CC-TAIX01 2 B01F-LB-03
S01F-MB-01 CC-TAIX01 2 B01F-LB-03
S01F-MB-03 CC-TAIX01 3 B01F-LB-04
S01F-MB-03 CC-TAIX01 3 B01F-LB-04
S01F-MB-03 CC-TAIX01 3 B01F-LB-04
S01F-MB-03 CC-TAIX01 3 B01F-LB-04
S01F-MB-03 CC-TAIX01 3 B01F-LB-04
S01F-MB-03 CC-TAIX01 3 B01F-LB-04
S01F-MB-03 CC-TAIX01 3 B01F-LB-04
S01F-MB-03 CC-TAIX01 3 B01F-LB-04
S01F-MB-03 CC-TAIX01 3 B01F-LB-04
S01F-MB-03 CC-TAIX01 3 B01F-LB-04
S01F-MB-03 CC-TAIX01 3 B01F-LB-04
S01F-MB-03 CC-TAIX01 3 B01F-LB-04
S01F-MB-03 CC-TAIX01 3 B01F-LB-04
S01F-MB-03 CC-TAIX01 3 B01F-LB-04
S01F-MB-03 CC-TAIX01 3 B01F-LB-04
S01F-MB-03 CC-TAIX01 3 B01F-LB-04
S01F-MB-05 CC-TAIX01 4 B01F-RB-01
S01F-MB-05 CC-TAIX01 4 B01F-RB-01
S01F-MB-05 CC-TAIX01 4 B01F-RB-01
S01F-MB-05 CC-TAIX01 4 B01F-RB-01
S01F-MB-05 CC-TAIX01 4 B01F-RB-01
S01F-MB-05 CC-TAIX01 4 B01F-RB-01
S01F-MB-05 CC-TAIX01 4 B01F-RB-01
S01F-MB-05 CC-TAIX01 4 B01F-RB-01
S01F-MB-05 CC-TAIX01 4 B01F-RB-01
S01F-MB-05 CC-TAIX01 4 B01F-RB-01
S01F-MB-05 CC-TAIX01 4 B01F-RB-01
S01F-MB-05 CC-TAIX01 4 B01F-RB-01
S01F-MB-05 CC-TAIX01 4 B01F-RB-01
S01F-MB-05 CC-TAIX01 4 B01F-RB-01
S01F-MB-05 CC-TAIX01 4 B01F-RB-01
S01F-MB-05 CC-TAIX01 4 B01F-RB-01
S01F-MB-07 CC-TAIX01 5 B01F-RB-02
S01F-MB-07 CC-TAIX01 5 B01F-RB-02
S01F-MB-07 CC-TAIX01 5 B01F-RB-02
S01F-MB-07 CC-TAIX01 5 B01F-RB-02
S01F-MB-07 CC-TAIX01 5 B01F-RB-02
S01F-MB-07 CC-TAIX01 5 B01F-RB-02
S01F-MB-07 CC-TAIX01 5 B01F-RB-02
S01F-MB-07 CC-TAIX01 5 B01F-RB-02
S01F-MB-07 CC-TAIX01 5 B01F-RB-02
S01F-MB-07 CC-TAIX01 5 B01F-RB-02
S01F-MB-07 CC-TAIX01 5 B01F-RB-02
S01F-MB-07 CC-TAIX01 5 B01F-RB-02
S01F-MB-07 CC-TAIX01 5 B01F-RB-02
S01F-MB-07 CC-TAIX01 5 B01F-RB-02
S01F-MB-07 CC-TAIX01 5 B01F-RB-02
S01F-MB-07 CC-TAIX01 5 B01F-RB-02
S01F-MB-09 CC-TAIX01 6 B01R-LB-01
S01F-MB-09 CC-TAIX01 6 B01R-LB-01
S01F-MB-09 CC-TAIX01 6 B01R-LB-01
S01F-MB-09 CC-TAIX01 6 B01R-LB-01
S01F-MB-09 CC-TAIX01 6 B01R-LB-01
S01F-MB-09 CC-TAIX01 6 B01R-LB-01
S01F-MB-09 CC-TAIX01 6 B01R-LB-01
S01F-MB-09 CC-TAIX01 6 B01R-LB-01
S01F-MB-09 CC-TAIX01 6 B01R-LB-01
S01F-MB-09 CC-TAIX01 6 B01R-LB-01
S01F-MB-09 CC-TAIX01 6 B01R-LB-01
S01F-MB-09 CC-TAIX01 6 B01R-LB-01
S01F-MB-09 CC-TAIX01 6 B01R-LB-01
S01F-MB-09 CC-TAIX01 6 B01R-LB-01
S01F-MB-09 CC-TAIX01 6 B01R-LB-01
S01F-MB-09 CC-TAIX01 6 B01R-LB-01
S01F-MB-11 CC-TAIX01 7 B01R-LB-02
S01F-MB-11 CC-TAIX01 7 B01R-LB-02
S01F-MB-11 CC-TAIX01 7 B01R-LB-02
S01F-MB-11 CC-TAIX01 7 B01R-LB-02
S01F-MB-11 CC-TAIX01 7 B01R-LB-02
S01F-MB-11 CC-TAIX01 7 B01R-LB-02
S01F-MB-11 CC-TAIX01 7 B01R-LB-02
S01F-MB-11 CC-TAIX01 7 B01R-LB-02
S01F-MB-11 CC-TAIX01 7 B01R-LB-02
S01F-MB-11 CC-TAIX01 7 B01R-LB-02
S01F-MB-11 CC-TAIX01 7 B01R-LB-02
S01F-MB-11 CC-TAIX01 7 B01R-LB-02
S01F-MB-11 CC-TAIX01 7 B01R-LB-02
S01F-MB-11 CC-TAIX01 7 B01R-LB-02
S01F-MB-11 CC-TAIX01 7 B01R-LB-02
S01F-MB-11 CC-TAIX01 7 B01R-LB-02
S01F-MB-13 CC-TAIX01 8 B01R-LB-03
S01F-MB-13 CC-TAIX01 8 B01R-LB-03
S01F-MB-13 CC-TAIX01 8 B01R-LB-03
S01F-MB-13 CC-TAIX01 8 B01R-LB-03
S01F-MB-13 CC-TAIX01 8 B01R-LB-03
S01F-MB-13 CC-TAIX01 8 B01R-LB-03
S01F-MB-13 CC-TAIX01 8 B01R-LB-03
S01F-MB-13 CC-TAIX01 8 B01R-LB-03
S01F-MB-13 CC-TAIX01 8 B01R-LB-03
S01F-MB-13 CC-TAIX01 8 B01R-LB-03
S01F-MB-13 CC-TAIX01 8 B01R-LB-03
S01F-MB-13 CC-TAIX01 8 B01R-LB-03
S01F-MB-13 CC-TAIX01 8 B01R-LB-03
S01F-MB-13 CC-TAIX01 8 B01R-LB-03
S01F-MB-13 CC-TAIX01 8 B01R-LB-03
S01F-MB-13 CC-TAIX01 8 B01R-LB-03
S01F-MB-15 CC-TAIX01 9 B01R-RB-01
S01F-MB-15 CC-TAIX01 9 B01R-RB-01
S01F-MB-15 CC-TAIX01 9 B01R-RB-01
S01F-MB-15 CC-TAIX01 9 B01R-RB-01
S01F-MB-15 CC-TAIX01 9 B01R-RB-01
S01F-MB-15 CC-TAIX01 9 B01R-RB-01
S01F-MB-15 CC-TAIX01 9 B01R-RB-01
S01F-MB-15 CC-TAIX01 9 B01R-RB-01
S01F-MB-15 CC-TAIX01 9 B01R-RB-01
S01F-MB-15 CC-TAIX01 9 B01R-RB-01
S01F-MB-15 CC-TAIX01 9 B01R-RB-01
S01F-MB-15 CC-TAIX01 9 B01R-RB-01
S01F-MB-15 CC-TAIX01 9 B01R-RB-01
S01F-MB-15 CC-TAIX01 9 B01R-RB-01
S01F-MB-15 CC-TAIX01 9 B01R-RB-01
S01F-MB-15 CC-TAIX01 9 B01R-RB-01
S01F-MB-17 CC-TAIX01 10 B01R-RB-02
S01F-MB-17 CC-TAIX01 10 B01R-RB-02
S01F-MB-17 CC-TAIX01 10 B01R-RB-02
S01F-MB-17 CC-TAIX01 10 B01R-RB-02
S01F-MB-17 CC-TAIX01 10 B01R-RB-02
S01F-MB-17 CC-TAIX01 10 B01R-RB-02
S01F-MB-17 CC-TAIX01 10 B01R-RB-02
S01F-MB-17 CC-TAIX01 10 B01R-RB-02
S01F-MB-17 CC-TAIX01 10 B01R-RB-02
S01F-MB-17 CC-TAIX01 10 B01R-RB-02
S01F-MB-17 CC-TAIX01 10 B01R-RB-02
S01F-MB-17 CC-TAIX01 10 B01R-RB-02
S01F-MB-17 CC-TAIX01 10 B01R-RB-02
S01F-MB-17 CC-TAIX01 10 B01R-RB-02
S01F-MB-17 CC-TAIX01 10 B01R-RB-02
S01F-MB-17 CC-TAIX01 10 B01R-RB-02
S01F-LB-17 CC-TAOX11 11 B01F-LB-02
S01F-LB-17 CC-TAOX11 11 B01F-LB-02
S01F-LB-17 CC-TAOX11 11 B01F-LB-02
S01F-LB-17 CC-TAOX11 11 B01F-LB-02
S01F-LB-17 CC-TAOX11 11 B01F-LB-02
S01F-LB-17 CC-TAOX11 11 B01F-LB-02
S01F-LB-17 CC-TAOX11 11 B01F-LB-02
S01F-LB-17 CC-TAOX11 11 B01F-LB-02
S01F-LB-17 CC-TAOX11 11 B01F-LB-02
S01F-LB-17 CC-TAOX11 11 B01F-LB-02
S01F-LB-17 CC-TAOX11 11 B01F-LB-02
S01F-LB-17 CC-TAOX11 11 B01F-LB-02
S01F-LB-17 CC-TAOX11 11 B01F-LB-02
S01F-LB-17 CC-TAOX11 11 B01F-LB-02
S01F-LB-17 CC-TAOX11 11 B01F-LB-02
S01F-LB-17 CC-TAOX11 11 B01F-LB-02
S01F-RB-01 CC-TDIL01 12 R01F-RB-01
S01F-RB-01 CC-TDIL01 12 R01F-RB-01
S01F-RB-01 CC-TDIL01 12 R01F-RB-01
S01F-RB-01 CC-TDIL01 12 R01F-RB-01
S01F-RB-01 CC-TDIL01 12 R01F-RB-01
S01F-RB-01 CC-TDIL01 12 R01F-RB-01
S01F-RB-01 CC-TDIL01 12 R01F-RB-01
S01F-RB-01 CC-TDIL01 12 R01F-RB-01
S01F-RB-01 CC-TDIL01 12 R01F-RB-01
S01F-RB-01 CC-TDIL01 12 R01F-RB-01
S01F-RB-01 CC-TDIL01 12 R01F-RB-01
S01F-RB-01 CC-TDIL01 12 R01F-RB-01
S01F-RB-01 CC-TDIL01 12 R01F-RB-01
S01F-RB-01 CC-TDIL01 12 R01F-RB-01
S01F-RB-01 CC-TDIL01 12 R01F-RB-01
S01F-RB-01 CC-TDIL01 12 R01F-RB-01
S01F-RB-04 CC-TDIL01 13 R01F-LB-01
S01F-RB-04 CC-TDIL01 13 R01F-LB-01
S01F-RB-04 CC-TDIL01 13 R01F-LB-01
S01F-RB-04 CC-TDIL01 13 R01F-LB-01
S01F-RB-04 CC-TDIL01 13 R01F-LB-01
S01F-RB-04 CC-TDIL01 13 R01F-LB-01
S01F-RB-04 CC-TDIL01 13 R01F-LB-01
S01F-RB-04 CC-TDIL01 13 R01F-LB-01
S01F-RB-04 CC-TDIL01 13 R01F-LB-01
S01F-RB-04 CC-TDIL01 13 R01F-LB-01
S01F-RB-04 CC-TDIL01 13 R01F-LB-01
S01F-RB-04 CC-TDIL01 13 R01F-LB-01
S01F-RB-04 CC-TDIL01 13 R01F-LB-01
S01F-RB-04 CC-TDIL01 13 R01F-LB-01
S01F-RB-04 CC-TDIL01 13 R01F-LB-01
S01F-RB-04 CC-TDIL01 13 R01F-LB-01
S01F-RB-07 CC-TDIL01 14 R01F-LB-02
S01F-RB-07 CC-TDIL01 14 R01F-LB-02
S01F-RB-07 CC-TDIL01 14 R01F-LB-02
S01F-RB-07 CC-TDIL01 14 R01F-LB-02
S01F-RB-07 CC-TDIL01 14 R01F-LB-02
S01F-RB-07 CC-TDIL01 14 R01F-LB-02
S01F-RB-07 CC-TDIL01 14 R01F-LB-02
S01F-RB-07 CC-TDIL01 14 R01F-LB-02
S01F-RB-07 CC-TDIL01 14 R01F-LB-02
S01F-RB-07 CC-TDIL01 14 R01F-LB-02
S01F-RB-07 CC-TDIL01 14 R01F-LB-02
S01F-RB-07 CC-TDIL01 14 R01F-LB-02
S01F-RB-07 CC-TDIL01 14 R01F-LB-02
S01F-RB-07 CC-TDIL01 14 R01F-LB-02
S01F-RB-07 CC-TDIL01 14 R01F-LB-02
S01F-RB-07 CC-TDIL01 14 R01F-LB-02

相同的16个1能不能1到16之间递增，一共有14个1到16递增怎么做

zpy2 · 发表于 2015-1-28 06:40:48

打运单号吧

roych · 发表于 2015-1-28 11:27:37

做成报表的话（报表属于静态窗体，只能用于打印展示，不能交互），其实很简单的，如图：

如果非要交互的话，则需要写代码在窗体里实现

帐号		自动登录	找回密码
密码			注册

群介绍
Access培训群 (792054000)
Access免费培训2群 (163530137)
Access免费培训群 (833510950)
Access免费培训群2 (792054000)
Access交流总群 (5004108)

主题相关群

地区相关群[您还没设置居住地]

[查询] 怎么把Layout表里的每行在查询表里每行增加16行

本帖子中包含更多资源

本帖子中包含更多资源

本帖子中包含更多资源

群介绍
主题无相 (随机显示版	同地区群块其他地区)