Recent content by Saeed Saj

Noted the contents and thanks The values cannot be stored each time as the values in each column changes at every transactions. So it can only be calculated at the time when required with the available figures in each column

Thanks for your explanation and it is quite clear. Appreciate if you can modify the query as explained in your reply in the attached db and post it. Thanks in advance

Can anybody help me solving this problem Here I have 3 tables. I want to retrieve data from these three tables in order to get a grand total for a Pcode during a particular year I have attached the db Here in Query1 the display of data is in a row which I am looking for but the figure...