Access 2007 Query returns blank results

[onlym]

I have Access 2007

I have tried to find the answer to this, but i have not found a simple answer. I have created a family business database ( i must state i am new to access) which works ok. I now want to run some queries but when i do they come back as blank fields. I guess its something to do with Relationships and Join Types, which i admit i dont fully understand Join Types

So not to mess up my database i created a simple 4 table database Table1, Table2, Table3 & Call.

I want to create a query from Call Table and add a field from each table Table1(LastName), Table2 (property), Table3(status). I will then set criteria on Status "Completed"

I suppose i need help on the correct way to join these tables together so the query works. Or you may say its something else.

Its probably something simple to someone.

Thanks

 

[JoanneJames]

Don't know if you a visual person or not, but at this link are diagrams showing how tables are interconnected. Basically to get data from multiple tables in one query, you have to 'join' those tables via foreign keys (FKeys). These diagrams illustrate some of those joins. http://www.google.com/images?hl=en&...esnum=2&sqi=2&ved=0CEsQsAQwAQ&biw=966&bih=573

 

[onlym]

Thanks, but the images you have directed me to do not explain what needs to be done, just show what has been done.

Onlym

 

[onlym]

Sorry, also i do not know Visual Basic

 

[JoanneJames]

I suggest you start studying Access help then. In the meantime, to get you started, here are some links:

http://www.brainbell.com/tutorials/ms-office/Access_2003/

http://www.meadinkent.co.uk/accqueryjoins.htm