Want certain criteria to appear on report.

[kenanselo]

Hi everyone,

I figured out how to get my report to display only ONE record from my form.

Now the next step is I need the report (from the form) to show ONLY certain data.



What I have are fields and checkboxes.

I want ONLY the fields below 4 to show and the checkboxes which are NOT checked to show in the report.

I figured that I would link the report to a query, but I'm not sure how I would go about doing the checkboxes and values below 4.

Thanks.

[kenanselo]

just wanted to clarify that i want certain FIELDS' results to show, ill give an example.

I want to show if and only if the values for Q1-Q10 are less than 4 and Q11-Q20 are NO (unchecked).

If they do NOT meet this criteria, then do NOT show them at all in the report.

Each Q is a field in itself so first i filter which ID in the record to show (already done) then how do i further filter this specific ID to show only the fields which meet this criteria.

Thanks.

[Rainlover]

This is not my database but it may be of help.

[kenanselo]

Sorry mate but the file gave me a few errors on load and I didn't really understand it much...any other solutions?

Thanks.

[Rainlover]

I did a download test and the file is not damaged. It might be because you are using 2007.