Search results

On the basis on data you provided in post # 3 in this thread how the resultant query should look like

Means you just want to have total balances / total ratio that doesnt seem complicated

What are the results you are expecting

I have created a sample with a custom function which calculates value with limit on form after each entry without saving any value in table Download the attached sample

You can creat a custom function get value at the time of entry on form Value can be calculated by looping through the recordset instead of saving data

I have created another query query17 based on your query16 and based the report on that query now it shows one line for opening balance Download the attached file

can you upload db with some dummy sample data

Is this limit for one week only ? In the next week will the running sum be started from 0 or it will be continued from running sum at the end of last week if it is continued when it will have to be zero one more thing how do you calculate the surplus and from which table it comes from

This a sample Main menu system using tabular form but looks like tree view

You can use the code on the "On Close" event of your form through which you change or enter new times My form was just a sample to show you how to do it you can use code any where directly as below CurrentDb.Execute "UPDATE Table1Sorted SET Table1Sorted.FlexiMax =...

You can save the results on which you want to apply this running sum in a temporary table and perform this task on that data

I have uploaded a sample Check data in table first Result is achieved by using three queries Chech them step by step Qry1 Qry2 Final Query (This query shows your required result) Regards Khawar

Download the attached file I have modified your query

I have attached a solution for you It updates the running total in the table you can modify it according to your requirements Hope this solves your problem

You can do this using vba this cannot be done directly in query

Check the query does it works now

you have to give some more information about you table and how are you storing the data

Can you explain in detail what are you trying to do and if more than one rows are displayed with different number in column master how should your query look like

Download the attached file and check query "yourquery" Hope it fulfills your requirement

upload some sample data if possible