Question for you - can you have more than one bubble / county selected at a time? If so, that becomes much more difficult, but if not, then use an Option Group.
Also, a lot depends on how you Normalized your data in your tables. Dawn Crosier "Education Lasts a Lifetime" This message is posted to a newsgroup. Please post replies and questions to the newsgroup so that others can learn as well. -----Original Message----- From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of takeadoe Sent: Wednesday, November 15, 2006 1:42 PM To: [email protected] Subject: [ms_access] Report Help Needed Please Dear NG - I'm very new to Access and reports are completely foreign to me. I was hoping that I could get some general guidance on how to proceed with the following: I've got a form (8.5x11") that is completed by the deer hunter when s/he presents the animal at a check station for permanent tagging. Data on the form is ultimately captured using OCR imaging software. There are a dozen or so fields. Some are choice fields (fill in the bubble) others are print fields where the hunter must enter data like name, DOB, DL#, etc. Ultimately, all of the data end up in an database (hence this email!). There are a number of occasions where I would like to reproduce the form (information requests, evidence, etc). However, since the images are not stored indefinitely, my thought was to create a REPORT in Access that mimics the form exactly. I'm sure I'm not the first to do this. In fact, I've read where you can import an image of the form and use it as a "template" for placing fields on your report. I can probably figure most of that out. My question for the group is this. How do I deal with the choice fields? For instance, there are 88 choices for county of harvest. All 88 counties are listed on the form, each with a corresponding bubble. How in the world do I tell Access which of those 88 bubbles needs to be darkened? Of course, I'm not looking for someone to do my homework. Guidance would be more than sufficient and greatly appreciated. If you could point me in the direction of some examples, that would be fantastic. If I've left you confused, I apologize. Please email me for clarification. Mike
