export number format

[wk6pack]

Hi,

I have tried to export the following query with the format function but I
still get values like 2.00 when I only want 2
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;

Am I doing something wrong??

thanks,
Will

 

[wk6pack]

I'm exporting the query. I run the query to see the dataset and then chose
file|export.

Hi Will,

Are you exporting the query or the table?

Hi,

I have tried to export the following query with the format function but I
still get values like 2.00 when I only want 2
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;

Am I doing something wrong??

thanks,
Will

John Nurick [Microsoft Access MVP]

Please respond in the newgroup and not by email.

 

[John Nurick]

What are you exporting it to? Are you using "Export formatted"?

The query you posted should export Type without no decimal places if
your exporting to a text file (certainly it works for me); but if you're
exporting to Excel or a database format things can be different and you
may need to format the data in the destination application.

I'm exporting the query. I run the query to see the dataset and then chose
file|export.

Hi Will,

Are you exporting the query or the table?

Hi,

I have tried to export the following query with the format function but I
still get values like 2.00 when I only want 2
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;

Am I doing something wrong??

thanks,
Will

John Nurick [Microsoft Access MVP]

Please respond in the newgroup and not by email.

John Nurick [Microsoft Access MVP]

Please respond in the newgroup and not by email.

 

[wk6pack]

I'm exporting to a text file. I dont know what happened but I opened the
file and it did work today. Maybe I didnt give it time to finish exporting
or it didnt overwrite the file.

thanks for you help.
Will

What are you exporting it to? Are you using "Export formatted"?

The query you posted should export Type without no decimal places if
your exporting to a text file (certainly it works for me); but if you're
exporting to Excel or a database format things can be different and you
may need to format the data in the destination application.

I'm exporting the query. I run the query to see the dataset and then chose
file|export.

Hi Will,

Are you exporting the query or the table?


Hi,

I have tried to export the following query with the format function but I
still get values like 2.00 when I only want 2
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;

Am I doing something wrong??

thanks,
Will


John Nurick [Microsoft Access MVP]

Please respond in the newgroup and not by email.

John Nurick [Microsoft Access MVP]

Please respond in the newgroup and not by email.