I have a table of chemical results based on ProjectID, From, To (SampleID) and a form that asks for the user to input ProjectID and select a subset interval (start From & end To) of which they want to calculate the sum product {(sum(chemresult*interval))/sum(interval)}. <br>
On the OnEnter of the "To" control on the form, I would like the result to appear in blank label underneath. I have been able to arrive at an answer using 3 cumbersom queries. I think there must be an elegent way to do this - by writing code? or a more efficient 1 step query? Any ideas would be very greatly immensely appreciated.<br>
loosing sleep over this one...<br>
thank you<br>
jelena
On the OnEnter of the "To" control on the form, I would like the result to appear in blank label underneath. I have been able to arrive at an answer using 3 cumbersom queries. I think there must be an elegent way to do this - by writing code? or a more efficient 1 step query? Any ideas would be very greatly immensely appreciated.<br>
loosing sleep over this one...<br>
thank you<br>
jelena