问题描述
希望有人可以帮助我。我有2个具有一对多关系的Access表。 1侧表保存计费信息,许多表侧保存计费ID和修饰符#。现在我需要将数据转换为:billing id,modifier1和modifier 2.
如果我进行交叉表查询,我会得到不同的修饰符作为列标题,但我只想要2列。
例如:
账单id修饰符1修饰符2
1100 50 49
1101 60 50
1102 47
1103 50
有人能否指责我取得成就这个。谢谢!
Hoping someone can help me. I have 2 Access tables with a one to many relationship. the 1 side table holds the billing information, the many table side holds the billing id and modifier#. Now I need to transpose the data into: billing id, modifier1, and modifier 2.
If I do a crosstab query I get different modifiers as column headings but I only want the 2 columns.
for example:
billing id modifier 1 modifier2
1100 50 49
1101 60 50
1102 47
1103 50
Can someone point me in the way of achieving this. Thanks!
推荐答案
这篇关于帮助转换数据itno列的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持!