Help with report please

  • Thread starter Thread starter Newz
  • Start date Start date
N

Newz

Hello All
I would appreciate it if you could give me a hand with a small problem i
have.

I would like to generate some reports... from an access database..
but rather than listing all records in ascending order of a field..

I would like to produce a summary report such as it counts how many entries
there are of a specific record..
for example:
i have a table where i record what students are abscent during the week.

so i would like to produce a report that will be like a table like below:

Sick accident discipline
Level 1 1 2 1
Level 2 2 3 3
Level 3 1 1 2

How can i do such a think

Thank you :)
 
Newz said:
I would like to generate some reports... from an access database..
but rather than listing all records in ascending order of a field..

I would like to produce a summary report such as it counts how many entries
there are of a specific record..
for example:
i have a table where i record what students are abscent during the week.

so i would like to produce a report that will be like a table like below:

Sick accident discipline
Level 1 1 2 1
Level 2 2 3 3
Level 3 1 1 2
Click to expand...


The first thing to do when creating a report is to put
together the query the report will be based on. The kind of
query you need depends on how your table(s?) are structured.

If you have a table with fields for Sick, Accident and
Discipline (not the recommended structure), then you can use
a Totals query to calculate the sums.

If you have separate tables for students and absences where
the absences table has fields for the studentID and a field
to specify the type of absence, then you would use a
crosstab query.
 
Back
Top