Conditional Format On Crosstab

[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.

 

[Kevin Jameson]

you cant do this with microsoft access 2003

you must upgrade to access 20004 by clicking here:
http://www.ammara.com/access_image_faq/access_loading_image_dialog.html

HTH

Kevin