如何合并访问行[已解决] [英] How do I merge access rows [SOLVED]

问题描述

Hello Everyone



我正在尝试将访问行值从一个表合并到另一个表

例如：

表1表2

产品名称购买数量>产品名称购买数量

洗发水2>洗发水3

洗发水1> / \ / \



CD 2> CD 4

CD 1> / \ / \

CD 1> / \ / \

（只是一个例子）

我从vb 6中的表格输入数据到表1

我想要正如我在示例中向您展示的那样，它将被排序并输入到表2中。我还希望每次在表1中插入数据时更新表2.



谢谢

Hello Everyone

I am trying to make an application to merge access row values from one table to another
For example:
Table 1 Table 2
Product Name Quantity Bought > Product Name Quantity Bought
Shampoo 2 > Shampoo 3
Shampoo 1 > /\ /\

CD 2 > CD 4
CD 1 > /\ /\
CD 1 > /\ /\
(JUST AN EXAMPLE)
I am entering data into table 1 from a form in vb 6
I want it to be sorted and entered in table 2 as I shown to you in the example. I also want to update table 2 every time data is inserted in table 1.

Thank You

推荐答案

"SELECT (Table).Productname, Sum((Table).Quantitybought) AS SumOfQuantityBought
FROM (Table)
GROUP BY (Table).Productname;"
(Based on my example)
(Table) = tablename you used

这篇关于如何合并访问行[已解决]的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！