Search results

I have a Pupils database where I have a form with Pupil name and ID. I have a query with a calculated field and the ID and this works great. I can display the associated calc on the form using a sub-form (I link the ID in the calc to the ID on the form) but I dont know how to get this value to...

I'm building a database to record which books Pupils at my school have read. I have 3 Tables with relationships between Pupils to Read and Books to Read: Pupils – ID, Forename, Surname Books - BookID, Book, Author, Level, Genre Read - ID, BookID, DateOut On another thread in the forum I got...

I'm building a database to record which books Pupils at my school have read. I have 3 Tables: Pupils - ID, Forename, Surname, ID Books - BookID, BookTitle, Author, Level, Genre Read - ID, BookID, DateOut I'd like to create a query that shows the BookTitle of the latest DateOut. Can someone...

Before I start, I consider myself a programmer who is punching far above his weight! I really struggle with SQL. I have a database for my school that I'm creating to log books read by Pupils. I have a Read table linked to both to a Pupil table and a Book table to say that the book has been...

Hi all, I work at a school and have a Reports database. I have a form for each subject and a number of fields per form. I'm trying to get the teachers to enter information about the kids into very precise boxes and then have that printed via Word mailmerge to produce end of year reports. So...

Hi guys - I work at a school and have a form that lists the classnames in a listbox. I have code that allows the selection of multiple items before it opens the form with pupils from the selected classes. This code worked when my database was mdb(2000) but now it is accdb (2007) it comes up...