More than 15 years in MS Access and my first Union query.
I have this union query:
How can I filter tblOrders with this filter: "RecID='K01-12-001D" without affecting the shown data from tblDummy?
It means that after filtering I need tblDummy shows its 2 record just like tblOrders is not filtered.
Thanks for any kind of advice.
I have this union query:
Code:
SELECT 0 As Expr1, RecID, Ordered_Part FROM tblOrders
Union ALL
SELECT Top 2 Expr1, '' , '' FROM tblDummy
How can I filter tblOrders with this filter: "RecID='K01-12-001D" without affecting the shown data from tblDummy?
It means that after filtering I need tblDummy shows its 2 record just like tblOrders is not filtered.
Thanks for any kind of advice.