J
Jeff C
I have a crosstab query sourcing a report. The dynamic columns are
date based. I want to add a conditionally formatted texbox so that the
color changes based on the relation of the most recent data to the last
ie: if Value wk 37 < Value wk 36 then the color would be red.
I have pre-set the column names in the query and placed them on the
report. How do I reference the most recent data so that I don't have
to re-write the conditions every week?
Thank you in advance.
date based. I want to add a conditionally formatted texbox so that the
color changes based on the relation of the most recent data to the last
ie: if Value wk 37 < Value wk 36 then the color would be red.
I have pre-set the column names in the query and placed them on the
report. How do I reference the most recent data so that I don't have
to re-write the conditions every week?
Thank you in advance.