Ok, If I do it that way it break it out all right but it is just totalling the Volume for all the entries recorded for that location which is not what I want. I want it to just give me the most current Inventory dates volume in the system for a location.

I am managing a pool of oil product basically.

thanks for your help

so basically

Toronto product a 6/4/06 45.6
Toronto product b 6/7/06 55.6
Edmonton product a 6/8/06 67.9
Winnipeg product b 6/7/06 98.5
Denver product c 6/2/06 45.8