Design question

[Edward]

Hi everybody,
I have a student table, class table and a table which has a combination
primary key (StudentId+ClassID) and a field which i called attended(yes/No)
..After I schedule students to a class and after class i go back and fill the
field for attend (If a student is attaended ,yes and if not dont check) I
need to generate a report that gives me list of all the students who are
scheduled for a class but didnt attend ( Attend field is no) in a given date
range

 

[John W. Vinson]

Hi everybody,
I have a student table, class table and a table which has a combination
primary key (StudentId+ClassID) and a field which i called attended(yes/No)
.After I schedule students to a class and after class i go back and fill the
field for attend (If a student is attaended ,yes and if not dont check) I
need to generate a report that gives me list of all the students who are
scheduled for a class but didnt attend ( Attend field is no) in a given date
range

Create a Query joining all three tables. Select the student's name from the
Student table, the class name and class date from the Class table, and the
checkbox field [attended].

Put a criterion on attended of

False

with no quotes, you can also use 0; and a criteron of

BETWEEN [Enter start date:] AND [Enter end date:] on the class date field. You
may also want to put a criterion on the class name.

 

[Edward]

Thank you so much it works. I have one more question. In my Class-Student
table which has three fields ClassId-StudentID as combined primary key,
Attend code (No Show, Conflict, attended, No Reason) , after I schedule each
student for a specific class I need to go back and fill that "Attend code"
field . I want to use a form for this and ideally when I select a class from
a combobox (it's date -time) I want to see all the students scheduled for
that class and then be able to fill thier attend code fields, Or any better
way that you can suggest? thanks again
--
Best regards,
Edward

Hi everybody,
I have a student table, class table and a table which has a combination
primary key (StudentId+ClassID) and a field which i called attended(yes/No)
.After I schedule students to a class and after class i go back and fill the
field for attend (If a student is attaended ,yes and if not dont check) I
need to generate a report that gives me list of all the students who are
scheduled for a class but didnt attend ( Attend field is no) in a given date
range

Create a Query joining all three tables. Select the student's name from the
Student table, the class name and class date from the Class table, and the
checkbox field [attended].

Put a criterion on attended of

False

with no quotes, you can also use 0; and a criteron of

BETWEEN [Enter start date:] AND [Enter end date:] on the class date field. You
may also want to put a criterion on the class name.

 

[Edward]

One more question. Your method about date range works fine but is there an
easy way to have those dates somwhere in the title area as well , I mean I
want my report to show the date range i have enetred below the title.
something like
General Report
01/01/200-01/01/2009
--
Best regards,
Edward

Hi everybody,
I have a student table, class table and a table which has a combination
primary key (StudentId+ClassID) and a field which i called attended(yes/No)
.After I schedule students to a class and after class i go back and fill the
field for attend (If a student is attaended ,yes and if not dont check) I
need to generate a report that gives me list of all the students who are
scheduled for a class but didnt attend ( Attend field is no) in a given date
range

Create a Query joining all three tables. Select the student's name from the
Student table, the class name and class date from the Class table, and the
checkbox field [attended].

Put a criterion on attended of

False

with no quotes, you can also use 0; and a criteron of

BETWEEN [Enter start date:] AND [Enter end date:] on the class date field. You
may also want to put a criterion on the class name.

 

[John W. Vinson]

Thank you so much it works. I have one more question. In my Class-Student
table which has three fields ClassId-StudentID as combined primary key,
Attend code (No Show, Conflict, attended, No Reason) , after I schedule each
student for a specific class I need to go back and fill that "Attend code"
field . I want to use a form for this and ideally when I select a class from
a combobox (it's date -time) I want to see all the students scheduled for
that class and then be able to fill thier attend code fields, Or any better
way that you can suggest? thanks again

Sure. You can use a Form based on the classes table, with a continuous Subform
based on the attendance table; use ClassID as the master/child link field, and
use a combo box based on Students bound to the StudentID and another based on
AttendCode (I presume you have a lookup table with the four rows) on the
subform.

 

[John W. Vinson]

One more question. Your method about date range works fine but is there an
easy way to have those dates somwhere in the title area as well , I mean I
want my report to show the date range i have enetred below the title.
something like
General Report
01/01/200-01/01/2009

Sure. Put two textboxes on the form with control sources

=[Enter start date:]

or whatever your prompt might have been.