Adding Text Box Values

[Chris Moore]

I have a simple report based on a query. The query groups data by office
location and provides a count of documents processed by each office for each
of three different date ranges. Example:

Office1: Jan: 100, Feb: 115, Mar: 95.

I ran the report wizard providing this query as the datasource. I am now
trying to add a text box to get a total count of documents for each office
but it's not working. Instead of a totaling the values Access is
concatenating them. So instead of "310" I get "10011595". Probably something
simple but I'm not seeing it. In the text box data source I have:
=[Jan]+[Feb]+[Mar]. What gives?

 

[KARL DEWEY]

It is treating them as text. Try this --
=CInt([Jan])+CInt([Feb])+CInt([Mar])

This converts them to integers.

 

[Chris Moore]

Yup. Problem Solved. Haven't run into that one before. Thanks for you're reply.

It is treating them as text. Try this --
=CInt([Jan])+CInt([Feb])+CInt([Mar])

This converts them to integers.

--
Build a little, test a little.

I have a simple report based on a query. The query groups data by office
location and provides a count of documents processed by each office for each
of three different date ranges. Example:

Office1: Jan: 100, Feb: 115, Mar: 95.

I ran the report wizard providing this query as the datasource. I am now
trying to add a text box to get a total count of documents for each office
but it's not working. Instead of a totaling the values Access is
concatenating them. So instead of "310" I get "10011595". Probably something
simple but I'm not seeing it. In the text box data source I have:
=[Jan]+[Feb]+[Mar]. What gives?