Question A little help on a report

[carriepedersen]

Hello

I'm trying to see if there is a way to create a report so that its formatted a little differently then the attached report.

I want to show the following:


Product WIT Code and then states across top and show the Tax Status below the correct state.

Example:

Product WIT Code AL AZ AR
FREIGHT 123456 T E T

Is this possible?

Thank you in advance for any help!

Carrie

 

[PaulO]

Should be possible ... by creating and using a CROSSTAB query (rather than a SELECT query) for your report.

If you've never done a crosstab query then you might find this a little tricky

In practical terms the major challenge will be accommodating 50+ columns of data on a single sheet? ;-)