Discussion Locked

Query works Report doesn't

0 helpful
3 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

I have a query using the following sql

PARAMETERS [Please enter Owner of Non-conformance] Text ( 255 );
SELECT audit_description.*, nonconformance.non_conformance_id, nonconformance.non_conformance, nonconformance.root_cause, nonconformance.nc_date_assigned, nonconformance.nc_assigned_to, nonconformance.nc_estimated_completion_date, nonconformance.corrective_action, nonconformance.verification_of_ca, nonconformance.documentation_updated, nonconformance.nc_actual_completion_date
FROM audit_description LEFT JOIN nonconformance ON audit_description.audit_no = nonconformance.audit_no
WHERE (((nonconformance.nc_assigned_to) Like [Please enter Owner of Non-conformance]) AND ((audit_description.audit_close_date) Is Null))
ORDER BY nonconformance.non_conformance_id;

This works as a query. I created a report using the wizard and it worked, however, I then formatted the report and it no longer worked. When I open the query from the report design and run it works. I'm very confused.

3 replies

by john_wills

Just a suggestion: look in the RecordSource property of the report: it may just have got deleted.

by rwaterfield

Thanks for the suggestion John but I think I must be missing some weird access thing going on.

I create the report using the wizard it works. I then format the report design so it looks ok and preview it. It doesn't work. I then close the report and open it from the database window and it works!

Very strange.

This discussion is closed to new replies.