Need to make a printable reprt from this database.

[Me]

I have two tables
tblStudentsList
StudentID LastName FirstName Grade HR Lunch Class

tblStudentsLunchAttend
ID (AutoNumber) StudentID LunchDate

I Have A Form
with a combo box which isused to scan in student ID numbers from their
ID card

Name cboStudentID
Control source StudentID
Row Source Type Table/Query
Row Source SELECT tblStudentslist;
Bound Column 1
Limit To List 1
Auto Expand Yes
Default Value Blank
Validation Rule Blank
Validation Text Blank
Enabled Yes

Five More Text Boxes for Full Name, Lunch, Grade, Class, Homeroom

Name Text 1
Control Source =cboStudentID.Column(1) - (2) - (3) - (4) - (5)
Format Blank
Decimal Places Auto
Input Mask Blank
Default Value Blank
IME Hold No
IME Mode No Control
IME Sentance Mode None
Validation Rule Blank
Validation Text Blank

Sixth Text Box

Name Lunch Date
Control Source Lunch Date
Format Blank
Decimal Places Auto
Input Mask Blank
Default Value =Date()
IME Hold No
IME Mode No Control
IME Sentance Mode None
Validation Rule Blank
Validation Text Blank

I would like to be able to print out a report of all the students that
were scanned into that lunch but limited to the students that actually
belong in that lunch. Each student in the table have the listing of
their lunch 3A, 3B and 3C which is the lunch I want the report for. I
could then pass this printout to the teachers and they will be able to
monitor if they have students that are going to lunch but not to their
class.

It would have Student's Full Name, Grade, Class, HR

 

[Duane Hookom]

Ignore your form for this procedure.
You start by creating a query that is based on your two tables. Add each
table to the query and create a join line between the StudenID fields of
each table. Add the fields you want to display in the report to the query
grid. Since you want to print the report for the current date, you can set a
criteria under the LunchDate field of:
=Date()

The create a new report based on your new query. View the Sorting and
Grouping dialog and set the fields that you want to group by in your report.
You can display Group Header or Footer sections and set properties to insert
appropriate page breaks.

Drag your fields to the report sections as needed and get them lined up as
desired. Preview and save your report regularly. I would name the report
"rptTodaysLunchAttendance".

 

[Me]

OK The report is working.
Is there a way to only show the names of students who belong in 3C
lunch and no others that were scanned in during that lunch?

 

[Duane Hookom]

Yes. Do some playing around and searching Help on queries and criteria.
Maybe look at this link http://www.fontstuff.com/access/acctut08.htm.

If you can't figure this out, come back with a question.

 

[Me]

Thanks Again!
I will try to figure this out.