Report headings from field info

[Barb R.]

I am trying to produce a report which in the table it
comes from there is a field with only 2 options. In my
report there are dollar amounts to each of these. My
report looks like this:

Job# Quote status Price
123 Open 123.00
123 closed 456.00

I want it to look tlike this:

Job # Open Quotes Closed Quotes
123 123.00 456.00

Is this possible?

 

[Duane Hookom]

Take a look at Crosstab Queries. Job# would be the Row Heading, Quote Status
as the Column heading, and Sum of Price as the Value.