access 2000 converting text to number format

J

john

a database in my office was created and the person who
designed it put every field in a table as a text field.
the numbers that are in those fields need to be change to
a number to related to other tables. is there VB code or
script to change it? or any other waY?
 

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

Excel does not accept text format! 0
Finding the proper style field and the numbered paragraph value within the style 0
How can the font and size of (all) citation numbers be altered? 1
Page numbering with Merged Document and IF statements 1
Move Chart with Text 0
Display bug in Word: tables disappearing on copy and paste of text with bullet points into table 2
"Compile error in table level validation expression " after format 0
Some mail merge fields not pulling into document 2

Top