Special format function to allow aggregate calculation

[accessfever]

I have concatenated the rounded value from a currency field with the value from a text field to a new field (e.g. 4.56 CHF or 1,789 EUR). I wonder if there is a special format function which allows aggregate calculation after I download the output to a spreadsheet.

Eg.

Row 1- 1.01 CHF
Row 2- 3.03 CHF
Row 3- 4.05 CHF

If I highlighted the 3 rows, then Excel would give me a total of 8.09
I rememeber a similar data (new field = dollars plus currency) sourced from SAP Net Weaver can do the aggregate calculation in Excel. Just curious if Access 2007 has a similiar format function like that.

 

[ajetrumpet]

i don't really think there is. are you asking this question about excel? you mean AFTER it's in Excel? I don't remember seeing anything that you can use, but I could be wrong. maybe the best best would be just to split the concats up into different fields? like, the numerics in the one field, and the currency identifiers in another. ???

 

[accessfever]

Yes, it is AFTER i download the query's result in an Excel. That's ok if there is no such format function in Access. Thanks!