Search results

  1. ADAM_AUS

    Problem Working out how to calculate multiple entitlement accrural rates

    Hi, I have a problem that is stumping me a little... I am trying to set up a tracking register that accumulates bonus payment entitlements at 2 different accrural rates. i.e. Travel Bonus $ Rate 1: 2 per year accrued daily (pre Jan 1, 2008) Rate 2: 3 per year accrued daily (Jan 1, 2008 -...
  2. ADAM_AUS

    Concatenating a UniqueID

    I am trying to create a uniqueID based on 2 fields. I am unsure as to where it is best to do this. In a table or in a query? The field names are [tblWOProgressDetail].[Activity] and [tblWOProgressDetail].[ResourceID] The output I am after is the same function as I would do in excel by...
Back
Top Bottom