this is my code. the error message is "the multi-part identifier "scheme.porchdm.transactn"could not be bound (#4104).
I designed the query in design mode, not actually by writing the SQL, so please keep answers simple.
SELECT [Outstanding Orders].supplier, [Outstanding Orders].name, [Outstanding Orders].order_no, [Outstanding Orders].line, [Outstanding Orders].wh, [Outstanding Orders].product, [Outstanding Orders].analysis_a AS [group], [Outstanding Orders].date_required, [Outstanding Orders].qty_ordered, [Outstanding Orders].qty_received, [Outstanding Orders].balance, [Outstanding Orders].packaging, [Outstanding Orders].[num ctns], [Outstanding Orders].tran_code3, [Outstanding Orders].memo1, [Outstanding Orders].memo2, [Q Numbers (qty not zero)].transactn, [Q Numbers (qty not zero)].vessel, [Q Numbers (qty not zero)].comments, [Q Numbers (qty not zero)].lot_number, [Q Numbers (qty not zero)].port_embark, [Q Numbers (qty not zero)].port_arrive, [Q Numbers (qty not zero)].leave_date, [Q Numbers (qty not zero)].arrival_date, IIf([receipt_date]<[arrival_date],"-",[receipt_date]) AS [WH date], [Q Numbers (qty not zero)].quantity_logged, [Q Numbers (qty not zero)].post_status
FROM [Outstanding Orders] LEFT JOIN [Q Numbers (qty not zero)] ON ([Outstanding Orders].line = [Q Numbers (qty not zero)].line_number) AND ([Outstanding Orders].order_no = [Q Numbers (qty not zero)].order_no)
WHERE ((([Q Numbers (qty not zero)].transactn) Is Null Or ([Q Numbers (qty not zero)].transactn) Like "K*" Or ([Q Numbers (qty not zero)].transactn) Like "N*" Or ([Q Numbers (qty not zero)].transactn) Like "P*" Or ([Q Numbers (qty not zero)].transactn) Like "M*" Or ([Q Numbers (qty not zero)].transactn) Like "A*" Or ([Q Numbers (qty not zero)].transactn) Like "B*" Or ([Q Numbers (qty not zero)].transactn) Like "C*"))
ORDER BY [Outstanding Orders].date_required;