Hello,
I'm trying to make a local application and I'm stuck.
I'm inputting data into a form ( linked to the table 'questions' ) and based on the data input, I let a query run a calculation ( query1 ).
This query1 creates new field names and the result of the calculations are numbers.
Here's my question :
A) How can I sort the field names based on the result of the query ? -> The query only calculates 1 record at the time ( with 30 columns ), as the application requests input and gives a related output ( output is 50 columns ).
B) I want to make a report from the sorted field names. However, based on the calculation of query1, I want to sort them into 4 groups ( group1, group2, group3, group4 ) which are defined by the value of the result ( like group1 >8, group2 >6, group3 >4, group4<=4 )
I guess it's easier if the field names are converted to column names with the value as the second column, but I don't manage to understand how to do...
Any help would be highly appreciated !