Access 2007 SQL Help
Results 1 to 6 of 6

Thread: Access 2007 SQL Help

  1. #1
    Join Date
    Dec 2013
    Posts
    3

    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.

  2. #2
    Join Date
    Oct 2006
    Location
    Sydney NSW Australia
    Posts
    247
    Where are you trying to perform a running total, is it a form, report etc.?

  3. #3
    Join Date
    Dec 2013
    Posts
    3
    I'm trying to run it in a query

  4. #4
    Join Date
    Oct 2006
    Location
    Sydney NSW Australia
    Posts
    247

  5. #5
    Join Date
    Dec 2013
    Posts
    3
    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.

  6. #6
    Join Date
    Mar 2014
    Posts
    1
    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
  •