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.