Search results

  1. ADAM_AUS

    Problem Working out how to calculate multiple entitlement accrural rates

    What I have is an entitlement accrural. Up until Jan 1, 2008, it accrued at 2 per year calculated daily. We then increased the entitlement to 3 per year. Drama i have is I have people who started before the change date (therefore needing a calc to work out the two different accrual rates to give...
  2. ADAM_AUS

    Problem Working out how to calculate multiple entitlement accrural rates

    Thanks for your help.... I absolutely appreciate any help I can get and have always had great support from this forum... Things like these examples often help me sort these problems out myself, but as you have noticed, this is a ripper..... I am thinking it might be easier if I work on a...
  3. 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 -...
  4. ADAM_AUS

    Populate Annual Calendar Report

    Following a few more hours looking at some of the great stuff in this site, I stumbled across some of my answers. I have attached some of my mods, but there are a few things I am struggling with... 1. All months show 31 days in the calendar form, and create errors if you accidently try to...
  5. ADAM_AUS

    Populate Annual Calendar Report

    firstly, thanks for allowing people like me who is slowly learning the Access Development ropes to see how these sorts of databases are programmed. Being able to open, view, modify and generally try to figure out what is actually happening in these examples helps me sooo much and I learn new...
  6. ADAM_AUS

    Concatenating a UniqueID

    Brilliant. Thanks. Quick question. At what stage should I expect to be able to this this with out asking simple stupid questions. So far it is a slow process...
  7. 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