Query problems

[Guest]

I have a database that someone helped me create and it seemed to work well
until I tried to make some reports.
There is one form called Inspection and a subform called Questions that are
used to enter data. There is an append query that I really don't what it does
and I think that it may be why my query is not working.
The info looks right on the forms and I entered 4 test inspections. When I
look at the tables it looks like it is storing a 1 and a 0 for each question
for each inspection form. I set up the answer field as a number field where
1=Pass and 0=Fail.
Any Suggestions?

 

[Van T. Dinh]

It sounds correct to me.

The Field is set up to store numeric and it stores numbers 1 and 0. The
association of 1 to Pass and 0 to Fail is the meaning that might or might
not have been incorporated into the database structure.

I guess if you want to see the words "Pass" or "Fail" in the Report, you can
use a translation/lookup Table to translate the numeric value 1 to the Text
"Pass" and 0 to "Fail". You can use the Format Property of the TextBox on
the Report also but this will be a bit more cryptic.