query is turning my results into text

  • Thread starter Thread starter tbmarlie
  • Start date Start date
T

tbmarlie

I'm creating a qry where I'm combining fields from separate tables
into one table. All of the fields that I'm combining are numeric
fields.

When I make the new table, though, they all convert to text fields and
then I can't combine the amounts together when I create a Total_Field.

Thanks
 
tbmarlie said:
I'm creating a qry where I'm combining fields from separate tables
into one table. All of the fields that I'm combining are numeric
fields.

When I make the new table, though, they all convert to text fields and
then I can't combine the amounts together when I create a Total_Field.

Thanks
Click to expand...

If you are combining these fields fields in an expression (NewVal: Val1 &
Val2 & Val3) this is normal behaviour. Try explicitly converting your
expression to the necessary conversion function. For example:

NewVal: CLng(Val1 & Val2 & Val3)

Ed Metcalfe.
 
Back
Top