Aerowolf
Programmer
- Nov 6, 2002
- 64
Here's what I've got...
2 tables and a query:
qry has list of store #s with address (store# is primary key).
tblOrders has orders
tblOrderDetails has order details
Here's the Record Source setting in the report property:
SELECT [qry].[STORE#], [qry].[TYPE], [qry].[CATEGORY], [qry].[CITY], [qry].[ST], [qry].[POSSESSION], [tblOrders].[PO#], [tblOrders].[DUEDATE], [tblOrderDetails].[PARTID] FROM ([qry] INNER JOIN tblOrders ON [qry].[STORE#]=[tblOrders].[STORE#]) INNER JOIN tblOrderDetails ON [tblOrders].[ORDERID]=[tblOrderDetails].[ORDERID];
The result is only a list of stores that have orders. When I try to set the join property to #2 (left?) for the join between the qry and the Orders table and try to save, I get the error "Join expression not supported".
I want to be able to show all of the qry along with associated orders and associated order details.
What am I doing wrong? Is this not possible?
Edwin
2 tables and a query:
qry has list of store #s with address (store# is primary key).
tblOrders has orders
tblOrderDetails has order details
Here's the Record Source setting in the report property:
SELECT [qry].[STORE#], [qry].[TYPE], [qry].[CATEGORY], [qry].[CITY], [qry].[ST], [qry].[POSSESSION], [tblOrders].[PO#], [tblOrders].[DUEDATE], [tblOrderDetails].[PARTID] FROM ([qry] INNER JOIN tblOrders ON [qry].[STORE#]=[tblOrders].[STORE#]) INNER JOIN tblOrderDetails ON [tblOrders].[ORDERID]=[tblOrderDetails].[ORDERID];
The result is only a list of stores that have orders. When I try to set the join property to #2 (left?) for the join between the qry and the Orders table and try to save, I get the error "Join expression not supported".
I want to be able to show all of the qry along with associated orders and associated order details.
What am I doing wrong? Is this not possible?
Edwin