I have made a database in access to randomly pick numbers. I just need to weight the numbers based on type. 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 being picked at 90% for example and the other types would be picked less likely. Maybe B types would be picked 70% of time and C and D types around 30%. Can anyone help guide me on this?