By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
446,397 Members | 1,467 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 446,397 IT Pros & Developers. It's quick & easy.

Lost the plot in design

P: n/a
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.
Nov 12 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
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.

Nov 12 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.