Hello,
I am writing a VB-Access application for cleaning services.
There are Customers table and Cleaners table. The customers pay for cleaning services. The cleaners work and get paid.
There is Cleanings table – every cleaning session that took place has an entry in this table.
There is payments table – every payment that took place has an entry in this table.
I need to implement a screen, which shows, for a specific customer, the history of cleanings and payments and balance. I implemented it with a (union) query and a table screen, but I don't know how to implement the "balance" column.
"Balance" column summarizes information from previous entries.
I guess there should be defined a certain date/time to begin from, when the balance was zero.
Is it possible with SQL query, to implement a field that gets data from previous rows of the query?
Alternatively, is it possible to write VBA code that adds into a column in a table screen that gets the table contents from a query?
Any other idea?
Thanks!
Tova