Hi,
I receive data each week that comes in Excel, but apparently from another system called Qlikview before that (which I don't have access to). One of the columns is called %TE and can have values such as
0%
10%
66.6666667%
or blank
They are left justified, there is no set number of decimal places, though the maximum appears to be six and when I import them to access, they appear as text.
But I need to do calculations on them, apply conditional formatting and display them in a report, preferably with no decimal places.
How should I go about converting this data to numeric in a "master query", the output of which would then be used in subsequent queries and reports.
Apparently changing the source is not an option!
I receive data each week that comes in Excel, but apparently from another system called Qlikview before that (which I don't have access to). One of the columns is called %TE and can have values such as
0%
10%
66.6666667%
or blank
They are left justified, there is no set number of decimal places, though the maximum appears to be six and when I import them to access, they appear as text.
But I need to do calculations on them, apply conditional formatting and display them in a report, preferably with no decimal places.
How should I go about converting this data to numeric in a "master query", the output of which would then be used in subsequent queries and reports.
Apparently changing the source is not an option!