Combining fields to have one value

[WingMaker]

Hi,

This might be a hard one, it might not. I am trying to combine repeating fields into one value. In the picture you see two entries that have the same value, Thailand and 5070-5984. I only need one, this is a portal. I need help on a calculation to just have one record. But the hard part is the number inside the bracket. I need to add those two numbers together.

so the it should be: Thailand[339] 5070-5984

Need Help?

Thanks

[comment]

We'll need a better description of your tables and their relationships.

Or perhaps this might help:

http://fmforums.com/forum/showtopic.php?tid/198526/

[mr_vodka]

This seems like it could be an issue with your structure. There is a method on here that we call Ugo's method that can simulate this but still it seems like your structure could be modified.

P.S. Sorry Michael I didnt see your post.

Edited October 6, 2008 by Guest

[WingMaker]

ok, I think I got it, but how do I add the quantities together?

thanks