export number format

  • Thread starter Thread starter wk6pack
  • Start date Start date
W

wk6pack

Hi,

I used a query and put in the following: format([type],"0") and it still
exports to 2.00?

SELECT ExportTable.UID, Format([Type],"0") AS fType, ExportTable.Firstname,
ExportTable.MiddleName, ExportTable.Surname, ExportTable.Username,
ExportTable.Password, ExportTable.Grade, ExportTable.School,
ExportTable.Classname, ExportTable.TeacherUID, ExportTable.Filler
FROM ExportTable;
OUTPUT:

ADTHOMAS1,2.00,ADRIANNA,,THOMAS,ADTHOMAS1,student,05,CRAIGFLOWER
ELEMENTARY,,,

What am I doing wrong?

thanks,
Will
 
Back
Top