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 [Non-text portions of this message have been removed]
