Put a value from Totalquery into variable

[irade92]

Hi
I have a query like this

SELECT qryBONUS_pre.PACIENT_ID, Sum(qryBONUS_pred.TOTAL) AS SumOfTOTAL
FROM qryBONUS_pre.TOTAL
GROUP BY qryBONUS_pre.PACIENT_ID;

I like SumOfTOTAL to put into a variable
How to do it

 

[spikepl]

This thing delivers more than one record, if you have data for more than one patient. You can pick up the data for the record of interest by using the function Dlookup. Use the documentation for that function.

 

[irade92]

This thing delivers more than one record, if you have data for more than one patient. You can pick up the data for the record of interest by using the function Dlookup. Use the documentation for that function.

Thanks a lot.