How to GroupBy and Count in Ranges Within a Query??

[KWHAT]

I think it should use GroupBy and aggregate functions to do the following steps I require, however I just can’t get this to work:
So say I have the table below but with more records
Price

Cost Zone     Zip Code     Weight(lbs)  Price     Cost     Freight Value
5                K0K          1209       0        135         289
5                K0K          157         0        135         0
5                K0L          1425       0         135        650
5                K0L          1425       0         135        1999

I wish to require a query stating that the count of “Freight Value” falls into one of the ranges

Zip Code    Range 0-500    Range 501-1000    Range 1001-2000
k0K              2                     0            0
K0L              0                     1            1

How is this possible to do this ?? if you need me to explain with more detail let me know, thank you up ahead!

[JoeM]

Create an IIF statement to return a 1 if you range is met, and then change it to an Aggregate Query summing those calculations, i.e.

SELECT 
   MyTableName.[Zip Code], 
   Sum(IIf(([MyTableName]![Freight Value]>=0) And ([MyTableName]![Freight Value]<=500),1,0)) AS [Range_0-500], 
   Sum(IIf(([MyTableName]![Freight Value]>=501) And ([MyTableName]![Freight Value]<=1000),1,0)) AS [Range_501-1000], 
   Sum(IIf(([MyTableName]![Freight Value]>=1001) And ([MyTableName]![Freight Value]<=2000),1,0)) AS [Range_1001-2000]
FROM MyTableName
GROUP BY MyTableName.[Zip Code];

[KWHAT]

Create an IIF statement to return a 1 if you range is met, and then change it to an Aggregate Query summing those calculations, i.e.

SELECT 
   MyTableName.[Zip Code], 
   Sum(IIf(([MyTableName]![Freight Value]>=0) And ([MyTableName]![Freight Value]<=500),1,0)) AS [Range_0-500], 
   Sum(IIf(([MyTableName]![Freight Value]>=501) And ([MyTableName]![Freight Value]<=1000),1,0)) AS [Range_501-1000], 
   Sum(IIf(([MyTableName]![Freight Value]>=1001) And ([MyTableName]![Freight Value]<=2000),1,0)) AS [Range_1001-2000]
FROM MyTableName
GROUP BY MyTableName.[Zip Code];

LOL thats exactly what i ended up doing after playing around with all night thank you!