Printable View
I am attempting to calculate a running total for an inventory database that I regularly use at work. I have not been successful in creating a running total. The best that I can do is have it show the final total in each of the fields in the "Cumulative Stick" column.
Where are you trying to perform a running total, is it a form, report etc.?
I'm trying to run it in a query
Have look at this site http://support.microsoft.com/kb/290136
I have another question (still concerning SQL). I am making a query and I want to have parameters set so that I enter a value and it will show me just the records that match the entered value. I can get that part without a problem. The issue is when the parameter box is left empty...it will not return anything. How can I set it up so that if there is no parameter entered into the box to return all records.
As for me it will be better in this case if the query return info with mistake rather than all records.