Hi all.
I have a form with a subform.
The form is client details.
The subform is appointment details (in data view...like a spreadsheet).
They are linked together by client number (but that doesn't show in the subform)
One of the columns I have in my subform is duration (of the appointment) called "Duration (mins)"
What id like to do ideally is, somewhere on the main form, have box that totals up the duration of the appointments that the client has.
I have followed the below YouTube (see 6:30 onwards ). However, where he uses two fields to calculate (ie field A * field B), id be wanting to sum one field.
Is this possible?
thanks y'all