Anigito
New Member
- Joined
- Jul 16, 2011
- Messages
- 17
- Office Version
- 2019
- Platform
- Windows
Dear Community,
My question might be a very simple to answer, since I haven't found related threads in the forum. I would really appreciate your support.
What I have:
2019 MS Office
Excel files with the same formatting used as linked tables
What I try to achieve:
Union necessary data for later processing via Access/Excel
What has been done:
Union query which looks like this:
Error:
Formatting for VALUE, YYYY, MM, WW should be number (as it is in the source file).
The query has been working well until recently, what exactly caused the issue, I cannot seem to find.
But the result of the query turns these values into text, disrupting further processing and reporting.
Question:
How to fix this format change?
I have tried to use VAL() function for numeric values, but it did not work.
My question might be a very simple to answer, since I haven't found related threads in the forum. I would really appreciate your support.
What I have:
2019 MS Office
Excel files with the same formatting used as linked tables
What I try to achieve:
Union necessary data for later processing via Access/Excel
What has been done:
Union query which looks like this:
SQL:
SELECT
KA,
[MODEL#SUFFIX] AS MODEL,
GDMI_Types.rTYPE as MEASURE,
VALUE,
YEAR as YYYY,
MONTH as MM,
WEEK as WW
FROM GDMI_2019_Q LEFT JOIN GDMI_Types ON GDMI_2019_Q.MEASURE = GDMI_Types.GDMI_TYPE
UNION ALL SELECT
KA,
[MODEL#SUFFIX] AS MODEL,
GDMI_Types.rTYPE as MEASURE,
VALUE,
YEAR as YYYY,
MONTH as MM,
WEEK as WW
FROM GDMI_2020_Q LEFT JOIN GDMI_Types ON GDMI_2020_Q.MEASURE = GDMI_Types.GDMI_TYPE;Error:
Formatting for VALUE, YYYY, MM, WW should be number (as it is in the source file).
The query has been working well until recently, what exactly caused the issue, I cannot seem to find.
But the result of the query turns these values into text, disrupting further processing and reporting.
Question:
How to fix this format change?
I have tried to use VAL() function for numeric values, but it did not work.
