Converting data

[JWG]

Using Access 2003 how do you convert a Character field to a numeric field in
a query?

 

[Maurice]

Depends if the character is a number. If so you could try:

Val([yourfield]) or Cint([yourfield])

hth