Access Report with multiple duplicated fields -seperate duplicated 1

[WhiskeyNovember]

I have a DB that keeps track of parts, these parts are assigned to a specific card to complete a job. I sort the report in ascending order using the cards number. some of these cards have more than one part, therfore the card number is repeated. I am asking if it is possible to modify the card number column in the report to highlight every other number or group of numbers. Basically I need it to highlight every other different card number set, it would highlight the first card number and all that were of the same number then skip the next section that were all the same also, but different from the first. like this
1
1
1(all ones being highlighted)
1
2
2(twos not being highlighted)
3
3(threes would be highlighted)
3
and so on and so forth for the rest of the output of my query.

 

[dhookom]

Add a group header for the card number and add a text box
Name:txtCount
Control Source:=1
Running Sum: Over All
Then use conditional formating for the CardNum field in the detail section. Set the Condition 1
Expression is [txtCount] Mod 2=1
and set the background to your highlight color.

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]
[blue]Ask me about my grandson, get a grand answer.[/blue]