Calculation of currency... (1 Viewer)

[access7]

Hello

Hoping someone can point me in the right direction please. I am creating a quick database for my hubby (keen gamer, under-statement!)

I have 4 fields on my form for Price: 'Gold', 'Silver', 'Copper' and 'Iron', I want to be able to create an extra field that will concatenate the 4 fields to give one value as a result.

Can anyone help?

Thanks in anticipation

 

[John Big Booty]

The sample here deals with RL currencies. However I image that with in game currencies you won't have to deal with exchange fluctuations, so you can simplify things a little