I have made a database in access to randomly pick numbers. The only only problem is that I want to weight certain types of part numbers by a field called P/N class. My query spits out the example below.
Example: Product Number P/N Class
102BD5-CS2-ZN1 a
5410CV-PL2-AL1 c
11738-LW-SS2 c
125200002BD3-SS1-EP a
222070BD2-1-CS1-ZN1 a
Product numbers have a class of A, B, C or D. I would like to weight A as 90-95% picked, B as 80-85%, C as 25-30 and D as 20-25.
The goal for my database is to NOT change my data in the table and use some kind of code to pull certain types of product numbers. I have experimented in VBA in modules, SQL in queries and macros but I still have not solve my issue of weighting.
Let me know if you can help me out. I feel that I am close.
Michael
Example: Product Number P/N Class
102BD5-CS2-ZN1 a
5410CV-PL2-AL1 c
11738-LW-SS2 c
125200002BD3-SS1-EP a
222070BD2-1-CS1-ZN1 a
Product numbers have a class of A, B, C or D. I would like to weight A as 90-95% picked, B as 80-85%, C as 25-30 and D as 20-25.
The goal for my database is to NOT change my data in the table and use some kind of code to pull certain types of product numbers. I have experimented in VBA in modules, SQL in queries and macros but I still have not solve my issue of weighting.
Let me know if you can help me out. I feel that I am close.
Michael
