Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!

Need A Formula For My Form

Discussion in 'Information Technology' started by ILIRI, Jul 28, 2006.

  1. ILIRI

    Expand Collapse

    "ILIRI" <iiliri@gmail.com> wrote in message news:...
    > Q.Can anyone help me with a formula.
    > - I want to put a feature in my database that would show delays based on
    > number of costumers.
    > On the form F1 I already have textbox #Customers and it is formated as
    > General Number where is stored number of customers. I like to add another
    > textbox (Delays) which would give the result in hourly figures based on
    > the number of the customers, as in the following example:
    > -If numbers in #Customers are as bellow the dealays shuld indicate on the
    > apropriate hours of delay as listed
    > #Customers: 0 to 10 11 to 20 21 to 40 41 to 70
    > DELAYS: 1 1 1/2 2 2 1/2
    > <-indicates hours of delays based on the number that exists on #/customers
    > box.
    > *NOTE: Delays textbox does not necesary mean tho have the figures as above
    > (1 1/2) they can appear in format:(1.5) as well
    > I belive that VBA code would do the job but i dont know how to begin with.
  2. Loading...

Since you're here... we have a small favor to ask...     Become a Supporter      ::     Make a Contribution     

Share This Page