Hi all,
I've created a cross tab query to display sum of values under dates grouped by month as column headings. I'm using this to populate a report, and I would like to format the text colour for values displayed under future month, ie. greater than today's date.
Is there a way to use the column heading on conditional formatting criteria? I can't think of any other way to do this!
Any help or suggestions would be appreciated. Below is a snapshot of my data:
Table
BillingID ContractID BillingValue BillingDate
1 45 £3,000 01/06/2012
2 45 £5,500 15/06/2012
3 45 £2,200 02/10/2012
CrosstabQuery
ContractID June July August September October
45 £8,500 £2,200
I would like to change the font colour of October's value (future date) on my report if possible.
Thanks!
I've created a cross tab query to display sum of values under dates grouped by month as column headings. I'm using this to populate a report, and I would like to format the text colour for values displayed under future month, ie. greater than today's date.
Is there a way to use the column heading on conditional formatting criteria? I can't think of any other way to do this!
Any help or suggestions would be appreciated. Below is a snapshot of my data:
Table
BillingID ContractID BillingValue BillingDate
1 45 £3,000 01/06/2012
2 45 £5,500 15/06/2012
3 45 £2,200 02/10/2012
CrosstabQuery
ContractID June July August September October
45 £8,500 £2,200
I would like to change the font colour of October's value (future date) on my report if possible.
Thanks!