how do i get a query/report not to ignore blank data?

[robbath]

Hello,

I want to set up a query and/or a report which will display data in two tables, linked to a common field from another table.

The structure is as follows:

A form and its details are recorded in tblForms, key field 'Form ID'. Each form may have a 'route type a' or a 'route tpye b' or both, so there is a 'tblroute type a' and 'tbl route type b' with ID, and linked to Form ID on tblForms.

So, when i create a query or report, and ask it to display the Form ID, and its corresponding route a and/or route b, it will only display those forms which have BOTH route a type and route b type.

However, some forms have one, some have the other, some have both.

How do i tell access to display ALL form IDs, and corresponding 'route a tpye' and 'route b type', and if there isnt say for example a 'route a type' for a form, to still display it (as blank say under the 'route a type' column) so it can display the 'route b type contents'?

I hope that makes sense.

I was thinking along the lines of criteria which justs selects all forms whether they have an entry in each table or not, and just to display blank in one column if say it doesnt have both route types.... but i dont know how!!

Cheers, much appreciated in advance.

Rob

 

[eradtke]

In your query when you join the tables you have 3 choices for the tpyes of joins. When you join the tables right click the line that joins the tables and click "join properties". You will have to specify include all records from tblForms and only those records from tblRoute that are equal. I believe this is what you are missing in the query to display all records. (I hope)