Data Type Change

S

Sash

I have a table with a field that is currently defined as text in a table that
I'm linking to. Recently I was requested to transmit a batch count that
would multiply this text field by a quantity field to provide an additional
check for the batch submitted.

Is there a way to change this field to a number just for this calculation?
Like TONUMBER(fldcode)
 
D

Douglas J. Steele

Depending on what type of number it is, look at CLng, CSng, CDbl or Val in
the Help file.
 
Top