Search results

I should have been more specific. Sorry. What I want to do is simpler. Just total values in 12 fields (months). In the screen shot you can see some people have donations in more than one month. I just want to total each row (record). Darn, it won't let me post an image! OK - here is it typed...

A Totals query would be OK. I actually tried it but it didn't work (probably got it wrong). Can you point me to something that describes the best way to set that up?

I'm not using a form or report, just managing data myself directly in the table & in queries. Wouldn't the same expression work? Right now I have a manually-entered total field, but I don't trust it. I wanted to use a calculated field to be sure the total was correct.

I'm trying to total currency fields (money donated each month in a year) into a single calculated field. The result would be a field showing total donations for each person for the year. The database has been converted to 2010. I've created an expression like "[field1]+[field2]", but no go. I...