Adding Text Box Values

  • Thread starter Thread starter Chris Moore
  • Start date Start date
C

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?
 
It is treating them as text. Try this --
=CInt([Jan])+CInt([Feb])+CInt([Mar])

This converts them to integers.
 
Yup. Problem Solved. Haven't run into that one before. Thanks for you're reply.

KARL DEWEY said:
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.


Chris Moore said:
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?
Click to expand...
Click to expand...
 
Back
Top