Results 1 to 1 of 1

Calculate Current Value based on Cost and annual depreciation?

  1. #1
    MarkVenes is offline Novice
    Windows XP Access 2010 32bit
    Join Date
    Nov 2012
    Location
    Lake Elsinore - Hell
    Posts
    24

    Question Calculate Current Value based on Cost and annual depreciation?

    I have several fields but these are relevant fields:

    Fields are as follows:

    Item: Text
    DatePurchased: Date (Short Date) = Date the item was purchased. Example: 2/12/2010
    OrriginalCost: Currency = Amount the item cost at the time of purchase. Example: $3,324.00
    Depreciation: Number (Byte) = Percentage per year to depreciate the item. Example: 10 (default value)
    ValueAsOfDate: Date (Short Date) = Choose the date to determine the value of the item. Example 4/15/2013
    CurrentValue: Currency = What the current value, in dollars, is of the item. ??????????

    I want the CurrentValue field to automatically calculate the value of the Item based upon the OrriginalCost field, the Depreciation field, the ValueAsOfDate field, and the DatePurchased field. Then to display that information in the form. For use in preparing Business Property Tax information.

    I was thinking DiffDate() and Format(), and Round() -to the lower full year- and have to have a Count() function too I guess. Mind boggling.
    This is what I have so far. I am a novice, But I have watched all the TrainSignal Videos.

    =[OrriginalCost]*(DateDiff("yyyy",[DatePurchased],[ValueAsOfDate],[«firstdayofweek»],[«firstweekofyear»]))*[DepreciationPerYear]/100

    This obviously does not work.

    I have been thinking on this for a couple of days and I am lost.

    There are three threads that get close but do not answer the question publicly or clearly.

    I figured it out! Thank you brain.

    The answer is:

    =[OriginalCost]-([OriginalCost]*DateDiff("yyyy",[DatePurchased],[ValueAsOfDate])*([DepreciationPerYear]/100))
    Last edited by MarkVenes; 12-01-2012 at 05:42 PM.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Calculate age based on birthday
    By MediaCo in forum Access
    Replies: 10
    Last Post: 10-14-2014, 12:00 PM
  2. How to calculate current balance on hand
    By fazly lee in forum Access
    Replies: 11
    Last Post: 09-05-2012, 08:16 PM
  3. Annual Review
    By kwilbur in forum Access
    Replies: 5
    Last Post: 01-03-2012, 08:33 AM
  4. Calculate one field based on another one
    By Douglasrac in forum Forms
    Replies: 7
    Last Post: 11-18-2010, 11:30 AM
  5. Replies: 3
    Last Post: 06-23-2010, 06:33 AM

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Tech Forums: Microsoft Office Forums