Data Type Change

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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)
 
Depending on what type of number it is, look at CLng, CSng, CDbl or Val in
the Help file.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Update field in related table 5
Calculate conditiona total at bottom of continuous form. 4
showing results of a SQL statement in code 2
LINK COMBO BOX WITH TABLE 1
Compile Error 11
Access Dcount (multiple criteria) 3
Import files into access 1
help with a loop 4

Back
Top