Simple Query Help

[efernandes]

HI,

I am sending ZIP file in attach with files in it. I would like some help to change the 'Q_test' query so that I can get the result shown in the excel file.

Regards,
Elio

 

[macca the hacke]

Change the query 'Q_test' to the following:

SELECT AP.id_sort, USER.fname, AP.nr_ap, [nr_ap]*[price_div_tot_nr_ap] AS Fvalue
FROM ([USER] INNER JOIN (SORT INNER JOIN AP ON SORT.id_sort = AP.id_sort) ON USER.id_user = AP.id_user) INNER JOIN Q1 ON SORT.id_sort = Q1.id_sort
GROUP BY AP.id_sort, USER.fname, AP.nr_ap, [nr_ap]*[price_div_tot_nr_ap]
ORDER BY AP.id_sort;