Export currency to numeric field in Excel?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

angbob - 27 Mar 2008 17:09 GMT

I have a query with this statement in some SQL:
Format([T1].[V]*[T2].[V2], "Currency") AS [Value].

When I export the query to Excel, the Value field is exported to Text, not
to a numeric Number type.
One consequence is that adding a SUM to the Excel column produces 0.

Is there a way to get Access to export to a numeric Number?

Reply to this Message

Jeff Boyce - 27 Mar 2008 20:11 GMT

One approach might be to use the CCur() function, but leave off the
"Currency" formatting. Perhaps that's adding non-numeric characters that
Excel is then interpreting to be text...

Regards

Jeff Boyce
Microsoft Office/Access MVP

>I have a query with this statement in some SQL:
> Format([T1].[V]*[T2].[V2], "Currency") AS [Value].
[quoted text clipped - 4 lines]
>
> Is there a way to get Access to export to a numeric Number?

Reply to this Message