Can I make a querie if no field exists in 1 of the tables

[Matrix_zero]

Ok, I am building a querie so that i can pull data from different areas. I work for an appraiser and our software is access based.

There are 4 tables I want to pull data from.

1) The property address / Tax Key number
2) The data on the house
3) The data on the land
4) The data on any recent sales

The problem i am running into is that when running a querie if the data is not in all 4 tables it will not pull any of it. An example is if there is no house on a property it will not pull any data at all. Same if there is not a sale. I have worked with VB before but am still alittle new with access. Can anyone help me? Or can anyone direct me to some good sights on querie building? My goal is to turn this into a form that can be used for others to access.

 

[Pat Hartman]

You need to change the join types from Inner to Left.

 

[MarkK]

Try...

If you are using the query designer, you can right click on the join line between tables and select 'Join Properties.' Tweak settings in this dialog to accomplish what you want to do.

 

[Matrix_zero]

Wow... just that simple... thanks alot!