Duplicates

vendredi 27 février 2015

I have a report and know how to hide duplicates. On this report I am hiding certain fields but not all of them.

For 2 fields I actually want to highlight the duplicates so instead of hiding I'd like to maybe out put a load of "*"s.



e.g instead of

1041081018…..JOB-046-14…..24-Feb-14…...ABC…..…...….....Switches off….…..…....Cable Faulty…….....Comp717-R……Cable

…..…..…..…..….JOB-030-14…..06-Feb-14….......…….…..... …..Intermittent Hanging….Flash problem. …...Comp962-R……USB

…..…..…..…..…..…..…..…..…..…..…..…..…..….......….… ...….....Intermittent Hanging...Flash problem.......Comp163-R. …..HD

…..…..…..…..…..…..…..…..…..…..…..…..…..…..…......… .……...Intermittent Hanging....Flash problem.......Comp167-R…....dimm

…..…..…..…..…..JOB-186-14. …..18-Jul-14…..…..…..…..... …...Freezes....................Freezes..........…. ..







I want



1041081018…..JOB-046-14…..24-Feb-14…...ABC…..…...….....Switches off….…..…....Cable Faulty…….....Comp717-R……Cable

…..…..…..…..….JOB-030-14…..06-Feb-14….......…….…..... …..Intermittent Hanging….Flash problem. …...Comp962-R……USB

…..…..…..…..…..…..…..…..…..…..…..…..…..….......….… ...….....Intermittent Hanging...Flash problem.......Comp163-R. …..HD

…..…..…..…..…..…..…..…..…..…..…..…..…..…..…......… ..……...Intermittent Hanging....Flash problem.......Comp167-R…....dimm

…..…..…..…..…..JOB-186-14. …..18-Jul-14…..…..….…..... …...Freezes....................Freezes..........…. ..********........********



Any help gratefully re

Duplicates

0 commentaires:

Enregistrer un commentaire

Labels