Contact Hours.....

[miscole]

I am currently creating a database for our Upward Bound Program. Part of the grant is to keep track of "contact hours" with our students (weekly/daily). I have created the database and have created fields for each subject area (i.e. composition, college tour, newsletter, etc). Here's the problem I'm having.....whenever I mark a field, say composition, I want it to automatically enter a "1" in the code field; when I enter a "x" in the college tour field I want it to enter a "2" in the code field.....

PLEASE HELP! I thought the If/Then statements would work but I'm not for sure how to tackle this! HELP if you can.

Thanks.

Mis

[BobWeaver]

I'm assuming that you will only check one item per record.

You can set up the Code as a calculated field with the following calculation:

Case(not IsEmpty(composition),1,

not IsEmpty(colegetour),2,

not IsEmpty(newsletter),3,

"")