Search results

I really appreciate the help thanks. I've learnt a such a lot here, it's just that I already had it working with subforms. Thanks again!

Just wanted to let everyone know that in fact I couldnt get text/list box to do what I wanted so I gave up and used subforms. Thanks anyway for your help.

Fantastic - Nearly there... 2 things : 1) The entry in my listbox is highlighted (black which I dont want) and 2) The list box doesnt "clear" when theres not an entry in the query for the ID

I guess Im doing something wrong as in the row source I put the name of the query (which has the 2 fields) and in the control source I can put literally anything and all I get is a list of what the query throws up...

No reason for the Listbox but the previous posts Ive read seem to suggest its easier doing it with a listbox rather than a textbox.

If I put the query in the record source I get all calculated fields rather than just the one for that record...

Hi - Thanks for your help. There are buttons on the form to move to the next record if thats what you mean?

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...

Im sorry I can only click the Thanks button once! Brilliant, fantastic, Thank you! Now comes the task of understanding the code.:p

Is there anyone that can help me on this? I feel its close

Attached is the database Im trying to get my query to work with. The Pupil table is held in a file called PACRdata which will need to be linked. Thanks to all..

Im afraid not - is there a possibility of uploading the DB anywhere or is that a request too far?

Thank you so much for your ongoing help but I'm getting Syntax error on the 2nd lot of code too... strange that the last character (d) is missing in the message? (thats not a typo)

Im obviously missing something. It looks like this has to be done with 2 queries? I am not an SQL programmer so this is my problem. I took the first lot of code and pasted it in and I get "Syntax error (missing operator) in query expression 'max(dateout) BeingRead" - I dont understand where...

I was in a quandry because it looked like my original post had changed substantially and as I hadnt had a further response I assumed that people thought it was solved - book title was being displayed (I apologise). With Inner join I couldnt get the book title. Believe me Ive tried left, right...

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 followed the Access Query Builder link on 3 tables and I'm nearly there I think. The code below still displays all the entries in the Read table rather than just the biggest(latest) date). It does show the Book name now... SELECT Pupils.ID, Max (Read.DateOUT) AS MaxOfDateOut Books.Book FROM...

The SQL generated from my query using READ & PUPILS is as follows: SELECT Pupils.ID, Max (Read.DateOUT) AS MaxOfDateOut FROM (Read) INNER JOIN Pupils ON Read.ID = Pupils.Id GROUP BY Pupils.Id; This shows 4 records (correct) and display ID and DateOut If I then include Read.BookID like so...

Sorry thats a typeo...

Ultimately I want to display what BookTitle each child last added to the Read table so it must link to Pupil... I can create a query that shows what time each Pupil last took out a book but I cant then get it to show what title that is and I did that using the Max and Group By options...