export number format

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

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
 
I'm exporting the query. I run the query to see the dataset and then chose
file|export.

John Nurick said:
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
Click to expand...

John Nurick [Microsoft Access MVP]

Please respond in the newgroup and not by email.
Click to expand...
 
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.

John Nurick said:
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
Click to expand...

John Nurick [Microsoft Access MVP]

Please respond in the newgroup and not by email.
Click to expand...
Click to expand...

John Nurick [Microsoft Access MVP]

Please respond in the newgroup and not by email.
 
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
John Nurick said:
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.

John Nurick said:
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.
Click to expand...
Click to expand...

John Nurick [Microsoft Access MVP]

Please respond in the newgroup and not by email.
Click to expand...
 
Back
Top