Format Query Results

[Glowackattack]

Hi,
I have a mutual fund performance query that calculates fund performance over a specified time. I then export this query to a spreadsheet.

When exported, the normal view of the performance result wold show up as .0006 rather than .06%, so i used the FormatPercent() function around my evaluation in the query to have it show as two decimal places as a percent. My problem is then that this number is stored as text when exported to a spreadsheet and not as a number.

Is there any way to have this show as a percent to 2 decimal places in another way??

Thanks for help in advance.

 

[SOS]

If you use the Excel Object Model to export you can format the field IN EXCEL instead of in Access. How are you currently exporting?

 

[Glowackattack]

I have a button with the following code:

stDocName = "Qry_PerformanceForSelectedCaseGROSS_ISIS_REVISION"
stFileName = "\\Fss-cfs1\indprod\Fund Information\Fund Performance\Working Doc\Monthly ISIS\ISIS Update " & mnth2 & " " & yr & " DATABASE OUTPUT.xls"


DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel9, stDocName, stFileName

MsgBox ("Report exported to " & stFileName)

 

[SOS]

If you send the query to Excel using this method, you can just modify the code a little bit to format what you want.

 

[Glowackattack]

Thanks I'll give that a try...