Are null records creating my problem

[Sgt Bilkp]

How-do!

Spot of bother with one of my reports. Bit of background first to help explain...

Have a Query (Query1) that pulls together data. Based on the criteria it outputs a single record (finds the serial number entered in another form).
This query contains basic info, some of which is linked through relationships.
Eg: Serial, Name, Age is in the main table, location, type and status are linked.

Also linked is the faults table. One machine can have many faults. The fault headings are not listed in the Query.

ON my report, it shows all the data from the query and lists all the faults for that machine. Now this works perfectly, unless there are NO faults. In this case nothing shows up at all - even the data from the query.

Why is this? And is there a way around it?

 

[boblarson]

Sounds like you need to use an OUTER JOIN in your query. Double-click on the line that links your two tables together and select the option that says something like "Select All from your basic table and only those records that match in your faults table"