Access 2000/2002 full right outer join help?

[cj92713696]

I am trying to utilize Access 2000 or Access 2002/XP to pull data from 4 tables. I am linking Transfer & Received via full right outer joins.

Table 1 : MasterInventoryItemList
ItemCode

Table 2 : InventoryItemAssoc
ItemCode
StoreCode

InventoryItemAssoc is linked w/MasterInventoryItemList with ItemCode.

Table 3 : Transfer
StoreCode
ItemCode
Quantity
Date

Table 4 : Received
StoreCode
ItemCode
Quantity
Date

Table 3 & 4 are linked as right outer joins. I'm trying to get the SUM(Quantity) for each ItemCode.

StoreCode = AIR
Date = BETWEEN @StartDate & @EndDate

I have read a lot of information about Access not supporting full right outer joins? Does Access 2002/XP support full right outer joins? Any help is much appreciated.

Thanks,
CJ

 

[BNPMike]

I may be wrong but I do not think ANSI supports full outer joins - you have to do a left then a right, and union them together. (as far as I know). mike.stephens@bnpparibas.com

 

[cj92713696]

Please view -

http://www.geocities.com/csperber/query.htm