I have the following problem (uppertunity).
I have a mainform with a combobox to select a month.
In a subform I have info about persons per month.
Mainform and subform are linked via a monthID.
So I can select a month and via a select query I have per person ours worked, ours vacation etc. What I want to do is add a field with the sum to date of vacation ours.
I tried to solve that with defining a function in my query, but then I get runtime error 3262, telling me that it is not possible to have a function looking at the same collection of data.
Is it possible to do this in an other way?
regards apestaart
I have a mainform with a combobox to select a month.
In a subform I have info about persons per month.
Mainform and subform are linked via a monthID.
So I can select a month and via a select query I have per person ours worked, ours vacation etc. What I want to do is add a field with the sum to date of vacation ours.
I tried to solve that with defining a function in my query, but then I get runtime error 3262, telling me that it is not possible to have a function looking at the same collection of data.
Is it possible to do this in an other way?
regards apestaart