Attendance Listing

[Sheri Emery]

Hi,
I have a database that keeps track of contact data in one
table and attendance data (able to be linked to the
contact data via a Student ID field). I'm wondering if
there is a way that I can create a form that will
automatically pull all of the active students and will ask
for the date only once. I'm hoping it can return it so
that I can just scroll down the list and check box those
students that were present on a specific date. For
example, if I wanted to use tomorrow (1/12/2005) as the
date, I'm hopeful that I can develop a form that would
allow me to update the attendance table by clicking on the
checkboxes for those students who showed up tomorrow.
Sorry if this doesn't quite make sense, but any help would
be greatly appreciated.
Sheri

 

[Lonnie]

Lets see if I understand? You need to create a query that
has both tables and link them by the student ID, If you
need to query for a specific date. Put the query in
design view under the date colmn in criteria row
put "[Enter Date mm/dd/yyyy]" this will prompt you for a
date. The query itself can have the fields you want or
all the fields but you only need to put one date field. I
hope this helps.

 

[Sheri Emery]

Thanks for the advice. I understand how to make use the
date column in that fashion, but won't a query look for
data related to that particular date (of which there
hasn't been any entered yet)? Maybe I'm just not quite
following. Basically, I want to make an attendance roster
that is also a form. I would open the roster (which has
already pulled and made new records for all of the current
students. Then I would scroll down and check "yes" for
those students who were present. This action would update
my attendance table, which would then update on reports
and subforms, etc. I really appreciate any assistance
that you can provide.
Sheri

-----Original Message-----
Lets see if I understand? You need to create a query that
has both tables and link them by the student ID, If you
need to query for a specific date. Put the query in
design view under the date colmn in criteria row
put "[Enter Date mm/dd/yyyy]" this will prompt you for a
date. The query itself can have the fields you want or
all the fields but you only need to put one date field. I
hope this helps.

-----Original Message-----
Hi,
I have a database that keeps track of contact data in one
table and attendance data (able to be linked to the
contact data via a Student ID field). I'm wondering if
there is a way that I can create a form that will
automatically pull all of the active students and will ask
for the date only once. I'm hoping it can return it so
that I can just scroll down the list and check box those
students that were present on a specific date. For
example, if I wanted to use tomorrow (1/12/2005) as the
date, I'm hopeful that I can develop a form that would
allow me to update the attendance table by clicking on the
checkboxes for those students who showed up tomorrow.
Sorry if this doesn't quite make sense, but any help would
be greatly appreciated.
Sheri
.

.

 

[hermie]

Hello Sheri

Just a question Why do want to record the attendance? In my schooldatabase I
only record the absences is less data? And I can calculate the days present
for each student.

Hermie

 

[Sheri Emery]

Hi,
We actually need to be able to keep a record of the dates
students attend, so we can see that information in
subforms and individual reports.
sheri

 

[Lonnie]

I don't know if I am still following or not? I would
create a query with both tables in it and create the
relationship based on the Student ID fild. Then I would
make the form off of the query. I would use a Calander
Button to enter my date. I don't know why you would need
to keep a date field in both records. it may be you need
to create a table to store all the information from both
tables after you enter it. It's hard to say without
seeing. You are more than welcome to send me this
database empty Please and I will look at it.
Sorry if this was no help.

-----Original Message-----
Thanks for the advice. I understand how to make use the
date column in that fashion, but won't a query look for
data related to that particular date (of which there
hasn't been any entered yet)? Maybe I'm just not quite
following. Basically, I want to make an attendance roster
that is also a form. I would open the roster (which has
already pulled and made new records for all of the current
students. Then I would scroll down and check "yes" for
those students who were present. This action would update
my attendance table, which would then update on reports
and subforms, etc. I really appreciate any assistance
that you can provide.
Sheri

-----Original Message-----
Lets see if I understand? You need to create a query that
has both tables and link them by the student ID, If you
need to query for a specific date. Put the query in
design view under the date colmn in criteria row
put "[Enter Date mm/dd/yyyy]" this will prompt you for a
date. The query itself can have the fields you want or
all the fields but you only need to put one date field. I
hope this helps.

-----Original Message-----
Hi,
I have a database that keeps track of contact data in one
table and attendance data (able to be linked to the
contact data via a Student ID field). I'm wondering if
there is a way that I can create a form that will
automatically pull all of the active students and will ask
for the date only once. I'm hoping it can return it so
that I can just scroll down the list and check box those
students that were present on a specific date. For
example, if I wanted to use tomorrow (1/12/2005) as the
date, I'm hopeful that I can develop a form that would
allow me to update the attendance table by clicking on the
checkboxes for those students who showed up tomorrow.
Sorry if this doesn't quite make sense, but any help would
be greatly appreciated.
Sheri
.

.

.

 

[hermie]

Hi shery

Because I not use the attendance in my database, last night I tried to make
one, not with a form but with an update query and that works good. I think
it should be possible to do this in a form.
Otherwise send me a copy of your database if you are interested in my
database i can send a copy too.

Hermie