A simple question (or not)

[pjmv]

I’m quite newbie with Access, so before I even try to go ahead and do this I would like someone’s opinion . This is what I want (sorry for the english):
- A database to record when students miss classes, that records the month, day, and time of day (9-10,10-11,etc.) and also the discipline that the student is missing;
-The results should be presented in a table (printed in landscape) with the days of the month (1,2,3 at the top) and the disciplines at the lines bellow
Example:

Day 1 2 3 4
Discipline English
.
Month Apr x
Month May x
.
Discipline Mathematics
.
Month Apr x
Month May x
.
- For each discipline the database should also tell me when the student have reached the maximum number of faults allowed for each discipline

This is just the concept but I just want to know if this is feasible
Paulo Vicente, Portugal

 

[Nouba]

you could accomplish your goal with a crosstab query on which your report should be arranged. It might be a little tricky to adjust the column headings in the report. In Roger Access Library you'll find an example (CrossTabReport).

 

[Pat Hartman]

The tables need to be organized something like:

tblProblemReports:
ProblemReportID (autonumber primary key)
StudentID
DateTimeOfProblem
ProblemID
AdditionalComments (memo)

tblProblem:
ProblemID (autonumber primary key)
ProblemDesc
MaxFaults

tblStudent:
StudentID (autonumber primary key or a value from your main student table)
LastName
FirstName
etc.

With these tables, you can use a crosstab query as Nouba suggested to make the report you have requested.