Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by alwayslearning

  1. alwayslearning

    Sum() a complex # in a Report???

    Tks for the tip! I did try the Nz function at one point... will try it again. Tks!!!
  2. alwayslearning

    Access version checking

    In Access, have you tried using the 'Help' menu item under 'About Microsoft Access' the information at the top of the window should provide you with the MS Access release and version number? This should give you the MS Access information only.
  3. alwayslearning

    Sum() a complex # in a Report???

    It turns out part of the database was unsuccessfully trying to divide a column by zero in the Query. When I deleted all zeros in the database Table and left the fields blank all formulae in the Report worked perfectly!!
  4. alwayslearning

    Access Reports Can't Sum()... Other recommended Report Software??

    Thank you again for your feedback and comments! It turns out my formula was not Summing() in Reports because one of the areas of the database Query was dividing by zero..(which it doesn't like to do). When I deleted the zeros in the database and left the fields blank, everything worked like a...
  5. alwayslearning

    Access Reports Can't Sum()... Other recommended Report Software??

    Thanks for the feedback! Have downloaded your suggestion and will check it out. I am trying to run a Report on a Query. The objective is to calculate accumulated depreciation on a Table listing the capital assets of the company. The formula in the Query is: Accum Depn: ([Purchase Price]/[Depn...
  6. alwayslearning

    Access Reports Can't Sum()... Other recommended Report Software??

    Any and all feedback is highly appreciated!!! It appears that MS Access cannot Sum() complex numbers in a Report... Are there other packages that make the process easy/seamless? i.e.: Crystal Reports? Others??? All comments appreciated!!!
  7. alwayslearning

    Sum() a complex # in a Report???

    Accum Depn: ([Purchase Price]/[Depn Period])*([# Months]) is a formula in my Query. The Query works fine... the Report doesn't Sum()... I have tried... =(Sum([Accumulated Depreciation Query]![Purchase Price])/ Sum([Accumulated Depreciation Query]![Depn Period])+1)*...
See more

Part and Inventory Search

Back
Top