Select Query expression building

  • Thread starter Thread starter Tracy
  • Start date Start date
T

Tracy

I have two table in my database. One that logs Monthly inventory, and
one that logs products. they are linked together by item id. When I try
to build a select query that would add up the quartly inventory totals
is is not "adding" the figures together. It is only placing the numbers
next to one another. For instance. instead of adding 87+15+62 and
coming up with 164 it is displaying 871562. Here is a copy of the
expression I am using.

Expr1: [tbl2005]![January]+[tbl2005]![February]+[tbl2005]![March]

Does anyone have any ideas?
 
Thanks so much for the reply...it was actually simplier than that. The
table that i pulled the query from was formatted as "text" instead of
"number". Gosh I'm so freaking stupid! haha thanks though!
 
Back
Top