Merging of Spares with the same P/N in 1 Table

[Gioconno89]

Dear All,
Good Afternoon.

I just started today to use Microsoft Access.

I need to write a query able to merge the spare parts contained in my Table that have the same Part Number.


The query should also update the quantity everytime a record with the same part number is found.

Any suggestions?

Thank you in advance for the support

[ranman256]

make Q1 that counts all the spare PN:
select PART#, count(Part#) from tSpares

this is a make table query and write results to a temp table: tPartCounts

make Q2 an update query, that joins the main table , tParts, with tPartCounts on Part#
add the Qty:

update tParts Set tParts.Qty = tParts.Qty + tPartCounts.Qty where tParts.Part# = tPartCounts.Part#

[DaveT99]

Hi Gioconno89
Nice to see someone else using MS Access for spares related activities. Do you want to connect on Linkedin my link is www.linkedin.com/in/davidthompsonreliability