数据输入所需的交叉表行为 [英] Crosstab Behaviour required for Data Input
问题描述
我正面临一个严重的问题。目前的数据显示如下，并以相同的方式输入。
服装款式总数量
UCPJ 1 32 12
UCPJ 1 30 55
UCT 1 S 25
UCT 1 L 100
用户要求是将数据更改为以下格式
Garment STYLE S / 30 M / 32 L / 34 XL / 36 XXL / 38
UCPJ 1 55 12 0 0 0
UCT 1 25 0 100 0 0
现在这种情况是交叉表查询的设计目的，但数据输入需要以相同的格式。它有什么选择来实施它？我的最后一招将是改变数据库设计。我是否创建了一个包含数据撤销，操作和保存的所有代码的表单？或者有替代方案吗？
I am facing a serious issue. The current data appears as follows and in entered in the same manner.
Garment Style Size Total Qty
UCPJ 1 32 12
UCPJ 1 30 55
UCT 1 S 25
UCT 1 L 100
User requirement is to change the data into the following format
Garment STYLE S/30 M/32 L/34 XL/36 XXL/38
UCPJ 1 55 12 0 0 0
UCT 1 25 0 100 0 0
Now this sort of thing is what crosstab query is designed for but the data entry needs to be in the same format. What options do it have to go about implementing it? My last resort will be to alter the DB Design. Do i create a form with everything coded which includes data retreival, manipulation and saving? or is there an alternative?
推荐答案
我面临严重问题。目前的数据显示如下，并以相同的方式输入。
服装款式总数量
UCPJ 1 32 12
UCPJ 1 30 55
UCT 1 S 25
UCT 1 L 100
用户要求是将数据更改为以下格式
Garment STYLE S / 30 M / 32 L / 34 XL / 36 XXL / 38
UCPJ 1 55 12 0 0 0
UCT 1 25 0 100 0 0
现在这种情况是交叉表查询的设计目的，但数据输入需要以相同的格式。它有什么选择来实施它？我的最后一招将是改变数据库设计。我是否创建了一个包含数据撤销，操作和保存的所有代码的表单？或者有其他选择吗？
I am facing a serious issue. The current data appears as follows and in entered in the same manner.
Garment Style Size Total Qty
UCPJ 1 32 12
UCPJ 1 30 55
UCT 1 S 25
UCT 1 L 100
User requirement is to change the data into the following format
Garment STYLE S/30 M/32 L/34 XL/36 XXL/38
UCPJ 1 55 12 0 0 0
UCT 1 25 0 100 0 0
Now this sort of thing is what crosstab query is designed for but the data entry needs to be in the same format. What options do it have to go about implementing it? My last resort will be to alter the DB Design. Do i create a form with everything coded which includes data retreival, manipulation and saving? or is there an alternative?
我认为您需要做的就是使用交叉表查询向导创建交叉表查询，如以下链接所述。您可以使用当前查询的详细信息（使用Qty而不是totalQty）作为base。交叉表的查询或源查询。响应向导提示，输入以下内容：
列标题：大小
值列：数量
行标题：所有其他栏目
http：//www.databasedev .co.uk / crosstab_queries.html
感谢您的回复，但正如我在原帖中所提到的，我需要以相同的方式输入数据和交叉表查询不可编辑。我该怎么做呢？
Thanks for the reply but as i mentioned in my original post, i need the data to be entered in the same manner and crosstab queries are not editable. How do i go about doing that?
感谢您的回复，但正如我在原帖中所提到的，我需要的数据是以相同的方式输入并且交叉表查询不可编辑。我该怎么做呢？
Thanks for the reply but as i mentioned in my original post, i need the data to be entered in the same manner and crosstab queries are not editable. How do i go about doing that?
你不是有一个目前使用的数据输入表格吗？只需将表单放在设计视图中，并根据需要定位控件;然后点击查看>更改标签顺序。如果您有，可以使用向导创建一个。并且您将继续使用您用于基础的相同数据源。查询上面。如前所述，交叉表构建在基本查询之上。
Don''t you have a data entry form that you are presently using? Just place the form in design view, and position the controls as needed; then click view > change tab order. If you have one, you can use the wizard to create one. And you would continue to use the same data ssource the you used for the "base" query above. As discussed previously, the crosstab is built on top of the base query.
这篇关于数据输入所需的交叉表行为的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
