Results 1 to 4 of 4
  1. #1
    uvdssdit is offline Novice
    Windows 10 Access 2013 32bit
    Join Date
    Apr 2018
    Posts
    2

    Access Expressions

    Hopefully I posted this question in the correct location.



    I am using Access 2013 and have a database built for tracking assets. I have been asked to report back to board on our assets with current values. I have Acquired Date, Purchase Price, Current Value, Yearly Depreciation, Salvage Value, and Usage fields that I think I need to use to calculate this. I have the Depreciation working using the Built-In->Financial->SLN calculating the yearly straight line depreciation value. I am wondering if there is a expression I could use that would put in the current value field the correct value from taking purchase price and minus the depreciation value * time elapsed to current date or at least current year and show that current value in the correct field on the form. As I said the Depreciation is working with the Calculated Data Type.

  2. #2
    NTC is offline VIP
    Windows 10 Access 2013
    Join Date
    Nov 2009
    Posts
    2,392
    Please post the correct formula using the field names.

  3. #3
    uvdssdit is offline Novice
    Windows 10 Access 2013 32bit
    Join Date
    Apr 2018
    Posts
    2
    I do not have any formula as of yet for the Current Value. I am using this for the depreciation - SLN([Purchase Price],[Salvage Value],[Usage])

  4. #4
    orange's Avatar
    orange is offline Moderator
    Windows 10 Access 2010 32bit
    Join Date
    Sep 2009
    Location
    Ottawa, Ontario, Canada; West Palm Beach FL
    Posts
    16,716

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

Similar Threads

  1. If Then Expressions?
    By FoxMan250 in forum Access
    Replies: 34
    Last Post: 05-08-2014, 12:30 PM
  2. Combine two Expressions into one?
    By drex in forum Queries
    Replies: 2
    Last Post: 04-08-2014, 08:51 AM
  3. Replies: 4
    Last Post: 02-20-2014, 02:40 PM
  4. Replies: 16
    Last Post: 01-31-2014, 07:50 PM
  5. Replies: 9
    Last Post: 11-04-2013, 03:16 PM

Posting Permissions

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