+ Reply to Thread
Results 1 to 2 of 2

Adding formulas to access?

  1. #1
    Registered User
    Join Date
    03-12-2012
    Location
    USA
    MS-Off Ver
    Excel 2010
    Posts
    23

    Adding formulas to access?

    I am trying to.


    [2009 Salary]: [Salary]*[2008Increase]+[Salary]

    Bonus: IIf([Performance]="Excellent",0.05*[Salary],IIf([Performance]="Good",0.025*[Salary],0))

    I need to add these formulas to my access database but I am having trouble doing so.

    What I did:
    I click "more forms" then pivotable, then formulas, then detail calculated field I input [2009 Salary]: [Salary]*[2008Increase]+[Salary] and I get error.

    I tried to attach but it's too big in size.
    I'm working my way up to the top of the ladder.

  2. #2
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs, CO
    MS-Off Ver
    MS Office 365 Version 2403 Win 11 Home 64 Bit
    Posts
    23,810

    Re: Adding formulas to access?

    Cross posted at:
    http://forums.aspfree.com/microsoft-...as-509828.html

    Please read this:

    http://www.excelguru.ca/content.php?184
    Last edited by alansidman; 04-16-2012 at 12:09 PM.
    Alan עַם יִשְׂרָאֵל חַי


    Change an Ugly Report with Power Query
    Database Normalization
    Complete Guide to Power Query
    Man's Mind Stretched to New Dimensions Never Returns to Its Original Form

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1