Conditional concatenation

F

fgwiii

Good morning,

I have a field that lists pages as follows:
1
2
3
3a
5
7
But I need to concatenate only listings of pages "3a","4" and 7" and leave
the other pages with no concatenation.

Can this be done?

Thank you,

Fred
 
R

Rick B

not sure what you mean. concatenate what with what?
In your example, there is no page "4".

Please explain in more detail. What is in your table, and what results are
you trying to achieve?
 
F

fgwiii

Sorry about that.

I need to concatenate only listings of pages "3a","4" and 7" with another
field that contains page sub numbers.

I know how to concatenate. It is excluding the unwanted pages from being
concatenated where I am having a problem/no clue!

1
2
3
3a
4
5
7


Thank you

Fred
 
Top