Multple Column Results

[dml5055]

Hi,

I'm trying to break out results from a single field into multiple columns based on multiple criteria.

An example is the field has different sales by different distances and i would like to break out the sales based on distance.

Sales by Distance <1
Sales by Distance >=1 and <5
Sales by Distance >=5 and <10

etc. I'm not sure which terms to search so i'm having a difficult time finding a solution.

Is this possible to do?



Thanks

[Micron]

Check out the Crosstab query wizard. I don't find them easy to create, but based on your limited information, it may be the solution as long as your table supports using one.