Report -Conditional Format with multiple conditions: Access 2007
Access, Database, Conditional formatting, Conditional statements, Microsoft Access, Database programming, Access reports
I am trying to generate a report that will change the font to different color if of a date field but the total number of days will change if another field = ?. So basically if [TYPE] = CHILD
then DATE()-30= (red font),
and DATE()-31 BETWEEN DATE()- 60= (yellow font)
and DATE()-61 BETWEEN DATE()- 90=greenfont)
......but...... if
[TYPE]= ADULT
then DATE()-90= (red font)
and DATE()-91 BETWEEN DATE()- 120= (yellow font)
and DATE()-121 BETWEEN DATE
()-150= (green font).
I know how to change the multiple fonts with the "Conditional" option under the "Design Tab"......the issue is setting those different font conditions along with the variation of the [TYPE] field for the same record without having to generate a 2 separate queries for all adults and all children but rather keep them together in the same report.
