birder1951
Technical User
I am trying to calculate totals for a database along the lines of:
Take previous value from a table field then add the sum of new events from another table and write this value into a form. This needs to be done for each occurrencs of an ident number within a query.
Something like: For each ident number, take the previous value, add the sum of the new values and write the information into a text box on the form.
Can somebody please help?
Take previous value from a table field then add the sum of new events from another table and write this value into a form. This needs to be done for each occurrencs of an ident number within a query.
Something like: For each ident number, take the previous value, add the sum of the new values and write the information into a text box on the form.
Can somebody please help?
