D
dlw
I have a database with numbers stored as strings- like
PRICE and QUAN. In a query, I can do something like TOT:
[PRICE]*[QUAN] and it does the math fine. If I try to
make a report out of the query, I get the invalid field
type error, and have to put the VAL() in.
This really screwed me up, because I inhereted the
database, and just assumed that numbers would be numbers
and text would be text.
Just something to be aware of...
PRICE and QUAN. In a query, I can do something like TOT:
[PRICE]*[QUAN] and it does the math fine. If I try to
make a report out of the query, I get the invalid field
type error, and have to put the VAL() in.
This really screwed me up, because I inhereted the
database, and just assumed that numbers would be numbers
and text would be text.
Just something to be aware of...