Query to show all books that wasn't borrowed by a reader

[eliW]

Hi friends,
How can I show by query all the books that has not been borrowed by a chosen reader?
My query setup is: Table 1 readers( name etc.)
Table 2 books (name etc)
Table 3 Table of borrowing dates linked by 1 to many link to tables 1 and 2
Sorry! I am not allowed to send images yet
Thank you in advance,
Eli​

 

[Trevor G]

Upload an extract of your database via another source like dropbox and place a link in you thread it will be easier to take a look from there.

 

[eliW]

Upload an extract of your database via another source like dropbox and place a link in you thread it will be easier to take a look from there.

Hi Trevor and thank you
The forum does not allow to attache links until one have 10 threads.
Tell me please If you need more details
Eli

 

[jdraw]

Please see http://www.access-programmers.co.uk/forums/showthread.php?t=212125

 

[eliW]

Please see

I tried that but there is no way to attach files at all even zipped files!
I cannot even quote your link:

To be able to post links or images your post count must be 10 or greater. You currently have 7 posts.

Please remove links from your message, then you will be able to submit your post.

 

[Trevor G]

You might need to have sent at least 10 threads (I think), but you should be able to use another option as I have mentioned then just copy the URL from Dropbox or who every you upload it into your thread that is permitted.

 

[jdraw]

The link is in the stickys in the Tables(Queries, Forms...) sections. I have attached a jpg of same.

 

[eliW]

impossible:
I wrote the link as text without http

//tinypic.com/r/2608lqs/5

Eli

 

[Trevor G]

Eli I was hoping you would have sent a link to download a sample of the database, it would be better that just showing the query as I don't know the structure of the tables and what the data looks like. Now that you have 10 threads perhaps zip and extract of the database into your thread.

 

[eliW]

OK i'll try my best.

 

[Trevor G]

Eli thank you for posting the database sadly I don't understand it as it is not designed in English, I am sorry to say I wont be able to offer assistance, perhaps add to your thread or start a new one the language name it has been created in.

 

[eliW]

Thank you Trevor,
I figured it out myself.
Eli