Report headings from field info

  • Thread starter Thread starter Barb R.
  • Start date Start date
B

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?
 
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.
 
Back
Top