Access query help

[angels2]

Part# QTY Future Current
168DWR 6 5/27/2006 5/27/2006
168DWR 6 5/27/2006 5/27/2006
168DWR 6 5/27/2006 5/29/2006
168DWR 6 5/27/2006 5/29/2006
168DWR 6 5/21/2006 5/22/2006
168DWR 6 5/21/2006 5/22/2006


The above table is a query result I need now to run a query from this information to sum the total parts for future 5/27 and omit any current with the same date so if I sum the 5/27 and omit the 5/27 in the current I would come up with 12 I just want to omit any that hae the same date in each column
Thanks for help

 

[PHV]

Something like this ?
SELECT [Part#], Sum(QTY) As Total, Future
FROM yourTable
WHERE Future <> Current
GROUP BY [Part#], Future

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[Golom]

Select [Part#], SUM(Qty) As [Quantity]

From myQuery

Where [Future] = #05/27/2006#
  AND [Future] <> [Current]

Group By [Part#]

[small]No! No! You're not thinking ... you're only being logical.
- Neils Bohr[/small]