Access sum columns in query

Hi Kevin,

all you need to do is write into the next coumn of the query design grid, write into the field cell the following, or rather your version of it. Total:([col1]+[col2]+[col3])

Instead of col1 and col2 etc put the actual field names containing the values to be added. If you have 12 fields named Jan, Feb etc then you will have 12 terms in the expression ie [Jan]+[Feb]...

Regards, Mark (delegate)