Lost the plot in design

[John M]

Hi,
I've produced a simple database for my school to keep a log of pupil
behavour incidents. This all seems very negative, so we would now like to
add to it a log of positive pupil activities. At first it seemed that we
could maintain the same table for both, indicating positive or negative for
each type of incident. However, it soon became clear that the fields were
not going to match up. The result is 2 tables one positive and one
negative - each incident has an ID number. One pupil may have several
incidents logged or none at all. (Pupil names are provided by a table where
each has a unique ID. This is strored in the positive and negative tables.)

Now her comes the problem. I want to be able to analyse this data together.
For example produce a chart containing infomation for a pupil about both
positives and negatives. I might want to do the same for groups of pupils.
Surely I ought to be able to do this with a query, but I get in the most
awful mess!

Any help would be gratefully received.

[PC Datasheet]

If both tables have the same fields although one is positive and the other is
negative, create a union query to combine the tables then do your analysis on
the union query.
--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
re******@pcdatasheet.com
www.pcdatasheet.com
"John M" <jo**@jmawer.demon.co.uk> wrote in message
news:c1*******************@news.demon.co.uk...

Hi,
I've produced a simple database for my school to keep a log of pupil
behavour incidents. This all seems very negative, so we would now like to
add to it a log of positive pupil activities. At first it seemed that we
could maintain the same table for both, indicating positive or negative for
each type of incident. However, it soon became clear that the fields were
not going to match up. The result is 2 tables one positive and one
negative - each incident has an ID number. One pupil may have several
incidents logged or none at all. (Pupil names are provided by a table where
each has a unique ID. This is strored in the positive and negative tables.)

Now her comes the problem. I want to be able to analyse this data together.
For example produce a chart containing infomation for a pupil about both
positives and negatives. I might want to do the same for groups of pupils.
Surely I ought to be able to do this with a query, but I get in the most
awful mess!

Any help would be gratefully received.