G Guest Jan 30, 2006 #2 If the field consist of numbers only with leading zero's, you can try val([FieldName]) or Format([FieldName],"#")
If the field consist of numbers only with leading zero's, you can try val([FieldName]) or Format([FieldName],"#")
R Rick B Jan 30, 2006 #3 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.
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.