All,
I have a simple database that stores values against KPI's. Each KPI is different - and as such can be in different formats (%, #, $ , etc)
Is it possible, when querying the data - to have the results of the data represented in the required formats?
The data at present is in a number format, and against each record I have created a field with the format in (%, #, $), Is it possible to create a field in the query that will look at the format field and apply that to the number?
Any idea's welcome.
Thanks.
I have a simple database that stores values against KPI's. Each KPI is different - and as such can be in different formats (%, #, $ , etc)
Is it possible, when querying the data - to have the results of the data represented in the required formats?
The data at present is in a number format, and against each record I have created a field with the format in (%, #, $), Is it possible to create a field in the query that will look at the format field and apply that to the number?
Any idea's welcome.
Thanks.