English 中文(简体)
我怎么能够把重复浏览量和数量领域汇总在管理系统接入表中?
原标题:How can I remove duplicate rows and sum the Quantity field in a MS Access table?

我在MS Access上工作,有一个有重复浏览和数量领域的表格。 我想通过删除重复和汇总数量领域来巩固表格。

我可以很容易地通过就所有领域和定量领域概要与专家组进行选择性询问来取得所需的结果,但我如何根据选择性询问的结果更新表格?

问题回答

暂无回答




相关问题
Handling no results for docmd.applyfilter

I have an Access app where I use search functionality. I have a TextBox and a Search Button on the form, and it does a wildcard search of whatever the user enters in the TextBox, and displays the ...

access query to filter and combine count

i have two access tables tableA num count 1 7 2 8 3 9 4 9 5 13 6 6 tableB num count 0 1 1 14 2 12 3 5 4 5 5 11 6 5 how can i create an access query that ...

How to show File Picker dialog in Access 2007?

I want to show a dialog where the user can pick a file, click OK, and then the path to the file will be saved in the database. I have just one problem, I can t figure out how tho show the dialog ...

MS Access: list macro from VBA

I have to deal with a few macros (not VBA) in an inherited Access application. In order to document them, I would like to print or list the actions in those macros, but I am very dissatisfied by ...

Returning row number on MS Access

I have 4 tables, from which i select data with help of joins in select query...I want a serial no.(row number) per record as they are fetched. first fetched record should be 1, next 2 and so on... In ...

热门标签