FINDING MAXIMUM VALUE IN A REPORT ROW 1

[STRATMAN1]

I have a report based on a crosstab query, with rows as "month" and columns as employee sales dollars for that month. I am trying to shade the highest value in each month row. The shading is not hard, but I dont know how to construct the code (have tried dmax function) when trying to find the max of column fields in each row. Have tried the dmax function, DMax("[joe]" "[sally], ... etc but cant figure out how to make an array out of the column field names. Perhaps there is an easier way. All good help appreciated. Thanks.

 

[hneal98]

What does your query look like? You might have to create another query and base it on your cross tab and then sort the new query to show the max first or last or however you want to view it.

 

[dhookom]

Please share your SQL view of your crosstab. I am not sure if Months or employees display as column headers.

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]