Show Form

I am not sure if this can be done or not. I have access and have never used it also have excel and word plus other microsoft programs. Or I am open to another way to do it. What I want to do is have one entry screen where I can enter the following. We are a small goat club.. non-profit looking for a better way to enter our show information and print out class sheets. Show Name Show Date 1 Show Date 2 Show Date 3 (Note the shows sometimes have two shows in one day AM and PM then a another show the following day AM. Show Judge 1 show Judge 2 Show Judge 3 This information will remain constant for each show while you are entering the other data. You just need to be able to choose which show the exhibitors are entering. On the forms they are usually designated by 1(AM) 2(PM) 3(AM) or X all shows. Then we enter the information off the entry form Last Name First Name Address City State Zip Phone Email Then we enter the animal information for each class they could enter 1 class or 15 or more classes usually the goat is only in one class. Show(s) See above 1,2,3, Class Number Post Entry (yes/no) Goat Name Reg No. DOB Tatoo/Microchip Sire Sire Reg No Dam Dam Reg No. Showmanship Name Grounds Fee This is usually a constant fee Entry Fees This is the entry fee usually the same but could change X the number of entries Late Fees Same Number of Late Fees x Dollar Amount Pen Number Same Number of Pens x Fees Pen Fees It would be wonderful if it would calculate the age of the goat from the date of the show. (see sample class sheet) All the classes are divided by ages. So if it could split them into the correct class numbers that would be wonderful. We need to before the show print out a form for each class with the following information on it. See Class Sheet Show (1) (2) (3) Date Show Name Judge Class Number Class Name Blank Spot for Number in Class Thenin a table form with lines Placed Blank Colum For Placing A count on the number of line of goats entered like 1,2,3, etc Name of Goat Birthdate of Goat Exhibitor Blank column for Checked in Also need additional lines for any people entering after the deadline and the availablity to add the late entries after the show to the program. I also need to be able to add all the placings of the animals for each class. Then it needs to be outputed to the Showresult_Champion form below and the same with the show results depending on wether it is 2 shows or 3 shows. Before the show we would print out All the class sheets. Plus it should print out blank entered championship sheets.. There is a Junior Champion Buck which includes all the classes in the Junior Buck Division - We normally have a line for the class number and for the placement of First Place and Second Place Same for Junior Champion Doe - Then there is a Championship sheet for Senior Champion Doe and Buck it has the same all the class numbers for each that make up that division and a line for placings of animals First and Second and Exhibitor. Then there is a Grand Champion Form which includes The Junior and Reserve Champion and the Senior and Reserve Senior Champion one for bucks and one for does. They choose one of these for each division as grand champion and reserver. I hope that makes sense. I am trying to explain this the best I can. Reports would be the class sheets Total income broken down by Class Entries, Pen Fees, Total number of pens ordered and exhibitors name, city/state List of Exhibitors Attending a certain show Show Results Forms Mailing Labels Exhibitors A plus would be the ability to upload the show results to a web page. I don't know if this is possible or if our little club can afford it. But I thought I would find out. Please PM me any questions or for clarification.