I
ILIRI
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.
- 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 wellI belive that VBA code would do the job but i dont know how to begin with.