Search results for query: *

Thanks once again for first class information...it works a treat. TM

Hi , I am setting up a database to hold classroom bookings for a school. I have a table called bookings which holds date, period (a number 1-7 denoting time) and staff id for the staff member booking that room. At the start of the year I need to populate the database with all the standard...

Thanks... I am a trainer and although we run courses in relational database design we also need to run very simple courses on flat file databases for teachers who just really want to know the basics. Part of this course is to teach very simple calculations in queries and I was asked if you...

Hi, I have a very simple table which holds assessment marks for a subject for each pupil i.e. Pupil , Assess1, Assess 2, Assess 3 J Smith 30, 40, 30 J Jones 20, 30, 50 .... I would like to create a new field called average and have the result of the average of the three assessments. I can...

Fantastic ...works a treat! This struggling little database designer from Scotland thanks you for saving her a load of time. Cheers TrshMcK

Hi, I am using Access 2000 to design a database for classroom bookings for a school. The report at the end has to be grouped by day ie all the bookings for a Monday (for a the whole month) in one group. I have a date field and a field call Bookday which is generated from the date using...