I'm trying to make a form in Micorsoft Access 2007 that will automatically rank my entires based on certain criteria. The end result will be a targeting system.
I have certain criteria in columns such as: # of products, 3 of disciplinary actions, # of days delinquent, etc. I want to make a ranking system where the computer can rank the entires I should target first.
I don't know if this is possible in access, but if you have a suggesstion please help.