Hello all,
I urgently require an access database. A small one and having never done one before have spent 2 weekends learning how via a tutorial. I have got as far as doing my tables, queries and can generate a report, so I guess I am getting there but now I need help with calculating

I have 4 fields in my form, with check box answers. So someone has to check either field 1,2,3, or 4. I have a field with Town name and they enter their town. That simple!

I print my report and it shows me a the towns, all individually even if two people state the same town, and it shows me all the check boxes individually.

I want it to say:
Town A 4
Town B 5
Town C 2

Field 1 4
Field 2 3
Field 3 2
Field 4 1

I really hope you guys can help, I have got this far with many hours and many headaches and really dont like to be at a loss, I have tried so many different things and not sure where to start at all!

I did a tutorial that said to go into design view and insert an unbound text box (which I know where to find) then click properties and in the control source build an expression - It has totally lost me and I am very tired but need this in a hurry!

Hope to hear from someone who can offer a suggestion to a complete novice

Thanks

... check either field 1,2,3, or 4 ...

If they can only select one value, then I would use an option group. This allow only one answer and it will return the desired vaule based ont he selection.

NO VBA code required.

Thank you for your reply.

There may be occassion where they could pick two choices, not a lot but it could happen so need the computer to tell me how many checks under each field.

I haven't learned 'options' at this time :-(


Thanks

Hi Can someone tell me if my original task can be accomplished. I am still fighting with this and getting into all sorts of trouble :-(

Thanks