Hi Guys , another query:
I know that running total function is designed for reports. i have been able to get it to function for forms as a calculated field. But can I make it work as a calculated field in the field rule in tables? I am not succeeding in the last three days.
I have 4 tables:
1. a_OPD
2.b_OPD
3.a_IPD
4.b_IPD.
1. Has fields which give charges collected from various hospitals on outpatient basis, for me.
2. Has charges collected from various hospitals on outpatient basis for my wife
3. same , but for indoor visits
4. For my wife indoor visits.
There are say 5 fields in each, each for each of the hospital. The topmostfield in each is the date field.
The last field in each table is "Total collection for the day" which is easy because it is Hosp A+HospB+Hosp C+ HospD+ HospE.
Now the 7th field I want in each table to be "Running total " for the month , so that it keeps adding the "Total collection for the day" daily, so at any given day, I can see the total sum so far.
This is possible on a report , but reports don't have colors and stylesheets. Is there a way to give this "running total " function to the last field at the field rule level, so it can run as a layout form" WITHOUT XBASIC, as I am not conversan with XBasic?
Sincerely,
Dr Alok Modi MD
I know that running total function is designed for reports. i have been able to get it to function for forms as a calculated field. But can I make it work as a calculated field in the field rule in tables? I am not succeeding in the last three days.
I have 4 tables:
1. a_OPD
2.b_OPD
3.a_IPD
4.b_IPD.
1. Has fields which give charges collected from various hospitals on outpatient basis, for me.
2. Has charges collected from various hospitals on outpatient basis for my wife
3. same , but for indoor visits
4. For my wife indoor visits.
There are say 5 fields in each, each for each of the hospital. The topmostfield in each is the date field.
The last field in each table is "Total collection for the day" which is easy because it is Hosp A+HospB+Hosp C+ HospD+ HospE.
Now the 7th field I want in each table to be "Running total " for the month , so that it keeps adding the "Total collection for the day" daily, so at any given day, I can see the total sum so far.
This is possible on a report , but reports don't have colors and stylesheets. Is there a way to give this "running total " function to the last field at the field rule level, so it can run as a layout form" WITHOUT XBASIC, as I am not conversan with XBasic?
Sincerely,
Dr Alok Modi MD
Comment