Expert: Scottgem - 5/23/2006

Question
How much does it cost to have someone make this for me?





I am not to familiar with Access, so I am not to sure on how to set it up. Any help you can give me would be most appreciated.  Thanks.




I need some help.    I am trying to set up some type of judging system.  I have 28 classes in a car show, each class has a letter and car number   (a1-a20, b1-b20 and so on). The people who entered their cars are the one who   vote for 1 car in each class and mark them all down on a voting sheet, then   they turn those sheets in and the votes are counted and added up.  I am trying to set something up so that all I have to do is enter the class   letter and car number (a1, x10, etc) and the program will then store all the   votes and then add them up for me, so I know which vehicles got the most   votes in which class..    To me it sounds like it would be some sort of inventory type system or   something, I am lost and need someones help ASAP in setting this up....  

Answer
I would be willing to give you a quote on doing this but I would need a bit more info.

Just to make sure I understand the application. You have various classes of cars to be entered in a show. Each car is then identified by a code that indicates the class and the car. Entrants indicate, on a sheet, which ONE car they want to vote on per class. You then want to show the number of votes given each car, per class.

What info do you need to store about the class? What info do you need to store about the cars? Do you need to store Entrants info? If so, what info? Do you need to identify each vote by entrant or just get a total of the votes? When entering the votes, do you want to enter all the votes on a ballot at once, or do you want to go class by class to enter the votes? Is there any other info you need to store?

Also what version of Access do you have?

Please e-mail the answers to me at scottgem@diamondassoc.com or scottgem@gmail.com. Copy this note into your e-mail. I'll then be able to give you a quote on doing this.

Scott<>