query outputs number as strings

  • Thread starter Thread starter aa
  • Start date Start date
A

aa

I have a field set a currency
When I run a query I have a resulting table with a corresponding field. Yet
when I copy a value from this filed and paste it into an Excel table the
value turns out to be a string.
Why so? Is it cirrect to think that when writing a query (I do it in SQL) I
need to specify that the output should be a number?
If so, how do I do this?
 
aa said:
I have a field set a currency
When I run a query I have a resulting table with a corresponding
field. Yet when I copy a value from this filed and paste it into an
Excel table the value turns out to be a string.
Why so? Is it cirrect to think that when writing a query (I do it in
SQL) I need to specify that the output should be a number?
If so, how do I do this?
Click to expand...

I have never worked with copying and pasting from Access to Excel, but
would that not need a "copy/paste/special??
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Access Field won't show as currency in the form, shows just a number (but works fine in the query) 1
Subquery Correllated In Select Clause - Is this possible? 3
Access Dcount (multiple criteria) 3
bitwise operator in SQL 3
Remove rows where specific field contains string value 2
Lookup query allows me to retrieve up to two rows. 1
Function as Query Parameter Not Working 6
NOT function not working - can prove with screenshots 1

Back
Top