Display error in report derived from a query | Access forum

Hello,

I have a query that is set-up to display information from three tables:
1. cases (fields include short text strings for names, as well as some dates)
2. personal (most data is stored in the True/False format)
3. attributes (most data is stored in the True/False format, although some fields include short text strings for names, as well as some dates).
When I run the report, the information is diplayed accurately in the Design View, and information saved in the True/False formats is displayed as 0 or -1 respectively.

I've created a report based soley on the query displayed above. Information from the attributes table is meant to be displayed using a series of Check Boxes.

The information selected to be displayed from the cases and personal tables is displayed accurately for all records in the report. However, there are several instance where the information selected from the attributes table isn't displayed at all, or is incorrectly displayed for some records.

How can I resolve this?