I have constructed a crosstab query and report based on it where I have two row headings: Region, and STatus. The only values in Status are "New" and "Old" The column headers are type1, type 2, and type 3, and the field values are an integer. I am trying to change the backcolor to yellow where in any region row intersect, i.e, region1/new/type1 and region 1 old/type1, the function selects the larger of the two and changes the backcolor. I tried conditional formatting in the Type 1 control, but could not construct the expression.It may require VBA code. All good help appreciated!!!
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Selecting Maximum Value between two rows of the same field
- Thread starter STRATMAN1
- Start date
Similar threads
- Locked
- Question
- Locked
- Question
- Locked
- Question