Hi, I would like to automatically to be able to move date from one table to another. My scenario is if I have a current client and enter an end date in the current clients table, to automatically move the record to the previous clients table (where I...

After solving an earlier query about setting my formula and linking a client and rates table I now need to create a column which averages out my earnings from clients. Should this be in my clients table or do I need to create a separate table for thi...

I want to calculate a value from one table multiplying it with a record value from another table. Can this be done please? Specifically, a number of consultations provided in one table, multiplied by a rate given in a different table.