Using Min to Calculate across a table

  • Thread starter Thread starter OlyOil
  • Start date Start date
O

OlyOil

I am attempting to massage data so I can see what the maximum number
of pieces I can produce based off of various components. My query to
figure out how many of each component is available per unit is
complete and the output is:

Part_Number, MaxComponent1, MaxComponent2,MaxComponent3, MaxComponent4

Does anyone have any suggestions as to how I could find the MIN of the
components and group by part number?

Cheers
 
See the MinOfList() function here:
http://allenbrowne.com/func-09.html

A better solution would be to create a related table with many records for
the combinations that are valid, instead of repeating fields in this table.

--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users -http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.









- Show quoted text -
Click to expand...

Brilliant! I had to play around with the code until I figured out what
the issues were with the data, but the code is fantastic! Thanks again
for the workaround!
 
Back
Top