[AccessD] Complex query....for me :-)

Hi group,

I've got a table with a field called [category] and a
field called [position].

I need a query that has several output fields:
New Pos, Old Pos, Delivered

The calculation for these fields is as follows:
New Pos = SUM(POSITION) WHERE CATEGORY = "NP"
Old Pos = SUM(POSITION) WHERE CATEGORY = "NZ"
Delivered = SUM(POSITION) WHERE CATEGORY = "DD"

But how do I create a query that spits out these
values??

Thnx.

Sander


	
		
__________________________________ 
Celebrate Yahoo!'s 10th Birthday! 
Yahoo! Netrospective: 100 Moments of the Web 
http://birthday.yahoo.com/netrospective/