Turn on thread page Beta
    • Thread Starter

    > 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
    > 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
    > well ( no tick).
    > How do I combine the tables or link them, without creating duplicates.
    > Many Thanks
    > Colin
    > [email protected]
Did you get less than your required grades and still get into university?
Useful resources

The Student Room, Get Revising and Marked by Teachers are trading names of The Student Room Group Ltd.

Register Number: 04666380 (England and Wales), VAT No. 806 8067 22 Registered Office: International House, Queens Road, Brighton, BN1 3XE

Write a reply...
Reputation gems: You get these gems as you gain rep from other members for making good contributions and giving helpful advice.