This discussion is closed.
colinneale
Badges: 0
#1
Report Thread starter 16 years ago
#1
Hi
> I want to produce a database that combines weekly accounts of pupils
> behaviour.
>
> The database is made up of tables that represent weekly accounts which
> consist of fields one of which is a Yes/No field which keeps track of
wether
> a pupil has behaved well or not, a tick meaning poor behaviour.
>
> I need to produce a query showing all of the puplis that have behaved well
> (no tick).
> The query is to span the whole year and my problem is that in one week a
> pupil may have behaved poorly ( a tick) and another week they may have
baved
> well ( no tick).
>
> How do I combine the tables or link them, without creating duplicates.
>
> Many Thanks
> Colin
> [email protected]
0
X
new posts
Back
to top
Latest
My Feed

See more of what you like on
The Student Room

You can personalise what you see on TSR. Tell us a little about yourself to get started.

Personalise

Have you made your firm and insurance uni choices yet?

Yes (117)
55.19%
Yes, but I want to swap them (16)
7.55%
No, but I know who I want to choose (19)
8.96%
No, I still don't know who I want to choose (50)
23.58%
I have decided I don't want to go to uni anymore and will not be choosing (10)
4.72%

Watched Threads

View All