Expression build in Access

[jayc28]

I have a table that has shipper zips(from) and consignee zips (to) plus dollar amounts for each of those shipments. Building a simple dupe query I see that the lane 30833 to 31401 has 3125 instances. I want to be able to display the total dollar amount from each of those instances. Does anybody have any idea of what expression or SQL statment I could use in order to do this?

Part of it I am sure is "If Shipper Zip = 30833 and Consignee Zip = 31401 _____ it is at this point that I get stuck.

Any help would be greatly appreciated.

 

[raskew]

You might try a variation of this, substituting your own table and field names:

SELECT zipfrom, zipto, Sum(amt) AS SumOfamt
FROM tblZipInstance
GROUP BY zipfrom, zipto
HAVING (((zipfrom)="30833&quot AND ((zipto)="31401&quot)
ORDER BY zipfrom;