R
Roger Bell
I have designed a data Base report which includes sorting and grouping with
the following Field/Expression:
=InStr("g1g3g4g6g7g9g10g11g13g14g15g17g18g20",Left([AccountNameBas],2))
The problem is that the report, based on the above, lists for example G1 and
G4 but does not list for example G14. If I change the ,2 to say ,3 it lists
g4 and g14, but eliminates g1
Can some one please advise where I have gone wrong?
Many thanks
the following Field/Expression:
=InStr("g1g3g4g6g7g9g10g11g13g14g15g17g18g20",Left([AccountNameBas],2))
The problem is that the report, based on the above, lists for example G1 and
G4 but does not list for example G14. If I change the ,2 to say ,3 it lists
g4 and g14, but eliminates g1
Can some one please advise where I have gone wrong?
Many thanks