weighted numbers macro

Jun 25, 2012
Reaction score
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?

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question