As I said, you may need to pass a parameter. Now back at my machine and can confirm that is the case. Example sql - note the criteria which 'resets'...
Thank you - this looked the most hopeful reply. Unfortunately I have not got it to work. Running with a stop of the rownum function - then yes it is...
The code executes but the relevant nodes are not bolded. I tried putting the subroutine in Form_Open and the code works as expected. I have a subform...
Instead of basing the final calculation on a previous calculated field, just repeat (include) the previous calculation in the final.
If that doesn't...
You tried SQL statement I suggested? I tested against your sample data and it returns 1 record. I suggested removing time parts because I thought all...