Microsoft access HELP... YIKES!!

[nessa]

i am in serious trouble. i've been working on this assignment for like, 12 hours now, and it still won't work
i have three tables already done in acces:
1)Author:
AUTHOR_Author Name (Primary Key) (txt)
AUTHOR_Gender
AUTHOR_University
AUTHOR_Faculty
AUTHOR_Department

2)Book List:
LIST_ID (primary key) (txt ISBN nbr)
LIST_Book Title
LIST_Book Author
LIST_Cost
LIST_Unit of Books
LIST_Publisher
LIST_Year of Publication
PUB_Publisher's Name (foreign Key)
AUTHOR_Author Name (foreign Key)

3)Publisher:
PUB_Publisher's Name (primary key) (txt)
PUB_Address
PUB_State
PUB_Country
PUB_ZIP
PUB_Phone Number
PUB_Website

i created a relationship using the look up wizard and in the relationship window i have a

Publisher (1)-(infinity)Book List(infinity)-(1)Author

now when i go to run queries which involve just one table it works

but as soon as i run queries with multiple tables, the query turns out blank.


i really need help!! sorry its so long winded, and thank you very very much if anyone can be of any help

 

[houssam_ballout]

have u tried to make the correct inner join between tables.??

 

[OS Dragon]

Just to clarify, is this a library database? I had a bash a making one and it wasn't that good compared to my friends but I was very proud of it.

 

[Hellbreather]

Can you help me help you and tell me
What queries your doing (what your looking for in it)

Thanks