I have 4 small queries(6 total fields) all with one common field. I need to link these to another querie with the same field. I want to create a table or querie that will contain values from all the queries using the one common field as the primary value. When I add the relationships and add all fields I get only the records that have data in all of the four origional queries. How would I create this table or querie to default to a zero if there is no data or record for one paticular value from the primary field

Change the join types to left.