microsoft access formatting

  • Thread starter Thread starter Guest
  • Start date Start date
If the field consist of numbers only with leading zero's, you can try

val([FieldName])

or
Format([FieldName],"#")
 
Please post an actual question using complete sentences.

One answer to your question (using as much detail as you gave us) would
be...

Change data type to numeric, not text.
 
Back
Top