-
Access 2007 SQL Help
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.?
Allan
-
I'm trying to run it in a query
-
-
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.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|