Search results

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...

I made up the sample in my last reply. My table has a ID number(primary key), a class and a product number. product number example = 3442-dh319h-10 I understand your method, but I do not want to change the tables unless it is my last option. How is it possible to have A types weighted...

What if I have: 1, A 2, A 3, A 4, A 5, A 6, C 7, C 8, C 9, C 10, D And I want use some kind of code in a macro or module to pull 90% of product numbers with A's and 20% of C's and D's. I understand the manual database of weighting items where I need to add more to obtain a better chance...

I have made a database in access to randomly pick numbers. I just need to weight the numbers based on the types of numbers. After a lot of research, I feel I need to make a macro that weights product number types. Some products would be A, B, C and D and A would weighted at a high percentage of...