query is turning my results into text

[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

 

[Ed Metcalfe]

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

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.