473,394 Members | 1,642 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,394 software developers and data experts.

Straightline Depreciation in Access 2003

15
Good morning all.

This is my first post to the site, and what a wonderful site this is. I wish I had come across it years ago. I am working on a database that is going to track the assets for a non-profit organization. One of the aspects which they wish to have happen is to have the database auto-calculate the depreciation value of any given asset (straight-line).

I have done several searches on this topic and in a previous post in the archives here it seemed to imply that there was a built-in straight-line depreciation calculation in access? I have not been able to find it. If anyone can tell me what it is or how to get it that would be great. I appreciate it!

(I'm sure this is probably one of the easier posts to respond to ... I will see what I can do to give some of you guru's a good challenge ;-)

Many thanks in advance!
Jul 14 '08 #1
3 5967
puppydogbuddy
1,923 Expert 1GB
Hi,
I believe what you are looking for can be found in the Asset Tracking sample database that comes with Access. Just click the access icon to start Access, then instead of opening an existing file, select Access Wizards.....
Jul 14 '08 #2
LosLobo
15
I do have that open, but I have not seen any specific calculation within that database. Perhaps I am not looking in the right spot, but while the tables have "sample data" in them, there is nothing specific as to the way it was calculated. The only thing that I have found to be true to form is the way they calculate the total depreciation, which is (presumably) a summation of posted depreciation amounts ...

Thoughts or other ideas are welcome.
Jul 14 '08 #3
puppydogbuddy
1,923 Expert 1GB
I do have that open, but I have not seen any specific calculation within that database. Perhaps I am not looking in the right spot, but while the tables have "sample data" in them, there is nothing specific as to the way it was calculated. The only thing that I have found to be true to form is the way they calculate the total depreciation, which is (presumably) a summation of posted depreciation amounts ...

Thoughts or other ideas are welcome.
See this link for the DDB method. The only difference between StraightLine and DDB is that SL does not have the "factor". Thus the annual SL depreciation would be computed as follows.

(Cost - Salvage)/Life

http://office.microsoft.com/en-us/ac...288181033.aspx
Jul 14 '08 #4

Sign in to post your reply or Sign up for a free account.

Similar topics

11
by: Wolfgang Kaml | last post by:
Hello All, I have been working on this for almost a week now and I haven't anything up my sleeves anymore that I could test in addition or change.... Since I am not sure, if this is a Windows...
10
by: Aaron Gray | last post by:
Hi, I have an application that uses 'strstream' in just under half its .cc files, about 10 files. What is the replacement for 'strstream' ? What are my options for replacing it ? Many...
10
by: Lauren Wilson | last post by:
Ok I have searched the MS website for info on this. I am totally confused. If I want to deploy an Access 2003 app and allow my users to run it using Access 2003 Runtime, where do I get the...
47
by: ship | last post by:
Hi We need some advice: We are thinking of upgrading our Access database from Access 2000 to Access 2004. How stable is MS Office 2003? (particularly Access 2003). We are just a small...
2
by: nejmay | last post by:
Help Please, I am taking a beginners VB.NET class and my next assignment making a Depreciation Calculator. I am suppose to use the built in functions SLN() and SYD() to perform the calus, option...
2
by: blagdam | last post by:
I am attempting to calculate the book value of assets in a query. I calculate total depreciation of the asset using the built in Strait Line Depreciation function and then use the following...
1
by: DaRok28 | last post by:
#include <iostream> using namespace std; int main() { int i, iYears; float fInitialVal, fSalvageVal; char cAgain; do
1
by: rjoseph | last post by:
Hi guys You've really helped me out in the past but now I really need your help! Basically I have a table (name=vehicletable) with the following fields/field data: Make Model Age ...
2
by: bossenb6 | last post by:
I have an assignment to calculate depreciation using straight line, double declining balance and sum of the years digits. Heres what I have so far, but I can't seem to figure it out. Please help!! ...
0
by: ryjfgjl | last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
0
by: ryjfgjl | last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
0
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
0
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
0
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...
0
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.