Hey guys,
I am building a simple database that tracks the parts used and the work done when a customer sends in a product to be repaired and returned (typical RMA). I have my tables and forms setup and working but now I need to make a query that summarize the total number of unique parts used in a given month, for external inventory purposes. The RMA form stores each part that is used in a given repair to an individual field.
Table Structure:
-Table for customers
-Table for testing, work done, and notes
-Table for all the part numbers (300+) and their descriptions
-Table to store all the parts that are used in each individual RMA (30 fields: part 1, part2...)
My query needs to add up all the unique parts used for a month and give the totals of each part used. I am stuck and looking for advise. Here is a picture of how my data looks in the test query.
How would I go about making this query do what I want? I will rep all who help, thank you very much!