Need to add values in a row

[4281967]

I have 12 columns named JAN to DEC.
On a report I want to add these values together. I tried placing a textbox out to the side and use this as the control source:
=[JAN]+[FEB]+[MAR]+[APR]+[MAY]+[JUN]+[JUL]+[AUG]+[SEP]+[OCT]+[NOV]+[DEC]
But that just concatenates the values together.

I also tried
=sum([JAN]+[FEB]+[MAR]+[APR]+[MAY]+[JUN]+[JUL]+[AUG]+[SEP]+[OCT]+[NOV]+[DEC])
that didn't work either.

 

[4281967]

I need to mention that the JAN-DEC colummns are made from a query....

 

[dhookom]

What is the SQL view of the query?
If the numeric values are being concatenated rather than added, you can wrap each month in Val() like:
=Val([JAN])+Val([Feb])...
I expect there might be an easier method in your query.

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]

 

[MichaelRed]

search these fora for basRowSum




MichaelRed