I have inheireted a database and not being a guru on the subject I wondered if some one could help.
Our database contains stores items and they are trying to print a report giving stocktake details. Everything looks ok apart from the totals for each group.
What is happening is that a total is being given but it is only taking the last figure in a section e.g. if you had 5 different types of loo cleaner in stock with values of 7.50, 10.50, 6.00, 3.75, 11.74 it would only take the 11.74 value to add to give the total at the end of the group.
The value of the individual stock items has been calculated using the formula =[unitprice]*[in stock] which is ok for totals of individual stock items. The value for each group total is calulated using =[typelinevalue] where linevalue is the name given to the individual totals for stock products.
I have tried changing the running sum options but to no avail, it still only takes the last figure in each section.
Does any one know why? Am I missing something really obvious?
regards...Andy.
Our database contains stores items and they are trying to print a report giving stocktake details. Everything looks ok apart from the totals for each group.
What is happening is that a total is being given but it is only taking the last figure in a section e.g. if you had 5 different types of loo cleaner in stock with values of 7.50, 10.50, 6.00, 3.75, 11.74 it would only take the 11.74 value to add to give the total at the end of the group.
The value of the individual stock items has been calculated using the formula =[unitprice]*[in stock] which is ok for totals of individual stock items. The value for each group total is calulated using =[typelinevalue] where linevalue is the name given to the individual totals for stock products.
I have tried changing the running sum options but to no avail, it still only takes the last figure in each section.
Does any one know why? Am I missing something really obvious?
regards...Andy.
