Conditional concatenation

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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?
 
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

R.I.P. Windows 7 - What next ? 5
Concatenating comments from consecutive rows together 1
Concatenate Error: It's just blank! 1
Concatenated Field - Sort Order 4
concatenate 1
2007 Concatenation problems 2
Concatenating multiple records into one text field 4
Concatenate multiple rows Into one Unique Identifier 1

Back
Top