Flagging a duplicate Field

[karlknoblauch]

I have a problem and am wondering if anyone has a solution. I have a table that contails the following info:

ID Invoice No. Product Soldby
123 a0001 Widgit FRED
134 a0001 Widgit RALPH
324 a3345 Thingy JOE
451 a9987 AMAJIG SALLY

The repot is grouped by Soldby user. When the report prints you get the following:

FRED
a0001 Widgit ****

RALPH
a0001 Widgit *****

JOE
a3345 Thing

And so on. What I am trying to do is FLAG any records that shares the same Invoice Number for different soldby users. So in the report above, both Fred and Ralph share the Invoice a0001 togehter. So the **** indicate this.

Any way to do this? I would appreciate any thoughts.

 

[synapsevampire]

If you grouped by invoice this would be much easier.

Otherwise you might want to use a subreport in the group header, which is linked by the Invoice No and does a distinct count and returns a shared variable of 1 or 0 which is used to identify if an invoice number has more than one.

-k