report/subreport conditional formatting 1

[psimon88]

Hello

I run a report for sales by rep by date. Inserted in the detail section of the main report is a sub-report with office totals by date (not by rep).

Is there a way for the conditional formatting (or some VB code, I suppose) to look at the rep's value for sales on a day and compare it to the office average, returning a color or format change if it's higher/lower.

Thanks.

sp

 

[dhookom]

You should be able to create a query that calculates the daily office average. Include this query in your report's recordsource and join the date fields. You can then compare the average to each employee.

If this doesn't work, come back with more information about your report's record source and your tables.

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]

 

[psimon88]

Thanks. I have such a query. When you write 'in the report's recordsource', are you referring to the main report or the subreport?

 

[dhookom]

In the report where you want to do the conditional formatting.

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]