question

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;