Report Format - Print different colors

  • Thread starter Thread starter pcslave via AccessMonster.com
  • Start date Start date
P

pcslave via AccessMonster.com

Have built a database into which data is inputted concerning Pickers and
Cases Picked. Have generated a report, based on a query, which works fine.
When the Supervisor runs the report, the query prompts for the beginning and
ending dates (usually a month at a time). The reports sums the data,
generating a cases picked per hour for each picker by the day of the week
(Monday, Tuesday, etc.). What I need to do is to cange the color of the font
based on a preset condition. I can change or highlight an entire row, but I
want to be able to change only the data listed under, say Monday, and only
for the data that meets the condition. In this manner, attention is drawn to
individual entries that require Supervisor review, vice highlighting an
entire row. NOTE: The condition changes depending of the day of the week but
is fixed for that day (until changed by management on a global basis). Any
assistance would be appreciated.
Thanks,
Mike
 
pcslave said:
Have built a database into which data is inputted concerning Pickers and
Cases Picked. Have generated a report, based on a query, which works fine.
When the Supervisor runs the report, the query prompts for the beginning and
ending dates (usually a month at a time). The reports sums the data,
generating a cases picked per hour for each picker by the day of the week
(Monday, Tuesday, etc.). What I need to do is to cange the color of the font
based on a preset condition. I can change or highlight an entire row, but I
want to be able to change only the data listed under, say Monday, and only
for the data that meets the condition. In this manner, attention is drawn to
individual entries that require Supervisor review, vice highlighting an
entire row. NOTE: The condition changes depending of the day of the week but
is fixed for that day (until changed by management on a global basis). Any
assistance would be appreciated.
Click to expand...


Try using Conditional Formatting (Format menu) on each text
box that you want to hightlight.
 
Back
Top