Any help is appreciated.

[El-Rafa]

Hello everyone,
I'm trying to get a DB for our church Sunday School, in
which those persons absent from each class on sunday
morning will receive a postcard stating that they where
missed.
The problem: I have 9 classes and from 3-19 students in
each class. Info. on each is basically:
(print) yes/no, Name, address, city, state,zip
I can make a list for each class, with a "check box"
(called Print) but don't know (1).how to ask the program
to print only those selected and (2). How to get it to
print this information in address labels.(I'll learn how
to get Access to print the postcards later, for now I'll
buy them...)
Please help if you can do this or guide me to a simple
template.

 

[Ed Warren]

Again the M:M dragon raises it's ugly head

You got

many people
many classes
IndividalPerson/Class/attended
many people in each class
each class has many people enrolled

You may need to redesign you database eventually into:

tblPeople (PeopleId, name, address, city, zip, telephone)
tblClasses(ClassID, Name,.... other stuff)
tblClassEnrollment (EnrollmentID,PeopleID,ClassId)
tblClassAttendance(AttendanceID, EnrollmentID, Date, Present (yes/no)

----------but all that is for later.

You have stated you have been able to produce a list with the names,
addresses, etc. and print (yes/no)

I presume you have arrived at this with a query or table.

Build a query based on the query/table above
qryPrint:
Select * from sourcequery where print=true
Now you have a list of only the rows you want to print.

Now open the report design wizard for labels and build a report based on
qryPrint above and the size labels you are interested in.

Print, enjoy.

Ed Warren.

 

[PC Datasheet]

You need the tables:

TblPeople
PeopleID
Name
Address
City
State
Zip

TblSundaySchoolClass
SundaySchoolClassID
SundaySchoolClassName
<<Other data you may want>>

TblSundaySchoolRoster
SundaySchoolRosterID
SundaySchoolClassID
PeopleID

TblAttendance
AttendanceID
SundaySchoolClassID
PeopleID
SundaySchoolClassDate
Attended (Yes/No)