Conditional format in a report

  • Thread starter Thread starter Conditional format
  • Start date Start date
C

Conditional format

I have a report based on a crosstab query with dates
accross the top and entities down the side. The values
are dollar amouns summed from a table with two relevent
fields: Amount and Source. There could be several
records from different sources that sum to the same cross-
section of the report.

What I want to do is: Let's say there are three records
that are summed to get the value shown in entity 1000 in
Jan-01 in my report. If the source field of any of those
records is "Region", I wan the fill color of that cross-
section to be light green.
 
Could you please enter a few resulting records into a message so we have a
better understanding of your query results? Then explain which
records/controls would have a different format.
 
Back
Top