Query to show all books that wasn't borrowed by a reader (1 Viewer)

E

eliW

Registered User.

Local time

Today, 08:33

Joined

Aug 16, 2013

Messages

14

• Aug 23, 2013

• #1

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​

 

Last edited: Aug 23, 2013

Trevor G

Registered User.

Local time

Today, 16:33

Joined

Oct 1, 2009

Messages

2,341

• Aug 23, 2013

• #2

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.

 

E

eliW

Registered User.

Local time

Today, 08:33

Joined

Aug 16, 2013

Messages

14

• Aug 23, 2013

• #3

Trevor G said:

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.

Click to expand...

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

Super Moderator

Staff member

Local time

Today, 11:33

Joined

Jan 23, 2006

Messages

15,379

• Aug 23, 2013

• #4

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

 

E

eliW

Registered User.

Local time

Today, 08:33

Joined

Aug 16, 2013

Messages

14

• Aug 23, 2013

• #5

jdraw said:

Please see

Click to expand...

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

Code:Copy to clipboard

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

Registered User.

Local time

Today, 16:33

Joined

Oct 1, 2009

Messages

2,341

• Aug 23, 2013

• #6

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

Super Moderator

Staff member

Local time

Today, 11:33

Joined

Jan 23, 2006

Messages

15,379

• Aug 23, 2013

• #7

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

 

Attachments

• 
  Larson_zip.jpg

  78.1 KB · Views: 64

Last edited: Aug 23, 2013

E

eliW

Registered User.

Local time

Today, 08:33

Joined

Aug 16, 2013

Messages

14

• Aug 23, 2013

• #8

impossible:
I wrote the link as text without http

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

Eli

 

Trevor G

Registered User.

Local time

Today, 16:33

Joined

Oct 1, 2009

Messages

2,341

• Aug 24, 2013

• #9

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.

 

E

eliW

Registered User.

Local time

Today, 08:33

Joined

Aug 16, 2013

Messages

14

• Aug 24, 2013

• #10

OK i'll try my best.

 

Attachments

• library.zip

  214.9 KB · Views: 74

Trevor G

Registered User.

Local time

Today, 16:33

Joined

Oct 1, 2009

Messages

2,341

• Aug 25, 2013

• #11

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.

 

E

eliW

Registered User.

Local time

Today, 08:33

Joined

Aug 16, 2013

Messages

14

• Aug 25, 2013

• #12

Thank you Trevor,
I figured it out myself.
Eli