Here is my challenge:
There is one form; frmCustomer + a subform on the frmCustomer. On the subform the user registrate the purchases the customer has done. The purchases have an automumber as their key.
In the report I want to select purchase no 1 to 75 f.i. and in the report I want to have a report for every purchase the customers has done containing the value for the present purchase for the customer, the value for earlier purchases the customer has done and the total value for all purchases for the customer.
I have grouped customer and I get the value for present purchase, the total value for all purchases for the different customers does however come up with the total for all purchases regardless of customer.
Does it make any sence???
There is one form; frmCustomer + a subform on the frmCustomer. On the subform the user registrate the purchases the customer has done. The purchases have an automumber as their key.
In the report I want to select purchase no 1 to 75 f.i. and in the report I want to have a report for every purchase the customers has done containing the value for the present purchase for the customer, the value for earlier purchases the customer has done and the total value for all purchases for the customer.
I have grouped customer and I get the value for present purchase, the total value for all purchases for the different customers does however come up with the total for all purchases regardless of customer.
Does it make any sence???
