I am a little new at CF so bear with me...
I have a query name get_totals as
'Select x, y, sum(salary) as salary
from table
group by x, y
(There will only be three instances of y and 10 instances of x ever!)'
I need to then assign variables to parts of the results of this query. For example, I want to set cri1 = salary
where x = 'illinois' and y = 'chicago'. I will eventually have 30 different variables from this data set, since there are 10 x's and 3 y's.
What is the correct syntax to assign these values to variables using just the get_project query or do I need use seperate queries to generate each?
Thanks in advance!!
Traci
I have a query name get_totals as
'Select x, y, sum(salary) as salary
from table
group by x, y
(There will only be three instances of y and 10 instances of x ever!)'
I need to then assign variables to parts of the results of this query. For example, I want to set cri1 = salary
where x = 'illinois' and y = 'chicago'. I will eventually have 30 different variables from this data set, since there are 10 x's and 3 y's.
What is the correct syntax to assign these values to variables using just the get_project query or do I need use seperate queries to generate each?
Thanks in advance!!
Traci