Forum Home
Press F1
 
Thread ID: 33265 2003-05-12 04:47:00 Access Bewildered (3777) Press F1
Post ID Timestamp Content User
143393 2003-05-12 04:47:00 I send letters to 37 departments each month. For every department, for each month, I'd like to record "Sent" (Y/N), "Answered" (Y/N), and "Number".
I'm having trouble with the concept! Should I have a form with 37 X 3 fields? That way, a record is a month. (I'd like to have all Departments on the form all of the time.) When I create a new record the fields would appear empty, and I'd fill in the data.
This seems a clumsy approach. Any better ideas?
Bewildered (3777)
1