Query data type results

[Leo_Polla_Psemata]

Dear friends

I have made a query which should returns text, numbers, date and currency
but unfortunately all data types are converted to "text".
I mean that, although I see, for example 29/08/2014 or $150, when I move it
to excel, i cannot make any calculation.

Is there any way i can denote to a query the correct data type ?

 

[Mile-O]

How are you exporting the query: the TransferSpreadsheet method or by copying and pasting?

 

[Leo_Polla_Psemata]

By copying pasting , does it make any difference ? I ll try

 

[Leo_Polla_Psemata]

Hi
This is the image from this query
Numbers and dates are treated as text.
There some DSUM ans DMAX functions behind query
What should I do in order to retrieve the numbers and dates in the correct data type ?

 

[JHB]

Dear friends

I have made a query which should returns text, numbers, date and currency
but unfortunately all data types are converted to "text".
I mean that, although I see, for example 29/08/2014 or $150, when I move it
to excel, i cannot make any calculation.

Is there any way i can denote to a query the correct data type ?

The query return the result in data types declared for the fields in the tables, (if the result is not cast to another type in the query!).
If you change the query to a "Make Table" query, then you are able to see the fields type.
The problem lies not in Access, but in the way Excel handled the inserted data.

 

[vbaInet]

From the screenshot every field is left aligned which would mostly indicate that the query itself is returning Text throughout, not unless you've manually changed the alignment (which I doubt). So the problem lies in the query. You're using functions that's coalescing the original type to a String type.

We need to see two things:
1. The SQL of the query. Copy and paste it here.
2. The field types of all the fields used in the query. Have a look in the table and write it here.