I
ILIRI
Can Anyone please help me with this situation.
Q. I have previously designed databes on Access 97, now I am asked to put
some extra features on it which involve calculating time.
What I wanted to do in form is adding another text box (ex. Box2) that would
show ([Box1] - 20 minutes). box1 already exists and contains data
------ ------
¦ box1 ¦ ¦ box2 ¦
------ ------
- Box1 shows inputed time in format hhnn (ex, 2215) and box2 has same
format.
I have already tried to put another textbox (box1a) that was not visible in
form view with default value 20 and format nn. Then on box2 i entered source
as: =[box1]-[box1a] but I didn't have apropriate result becaus calculation
dit not efected time but date in stead.
how should I resolve this situation.
Q. I have previously designed databes on Access 97, now I am asked to put
some extra features on it which involve calculating time.
What I wanted to do in form is adding another text box (ex. Box2) that would
show ([Box1] - 20 minutes). box1 already exists and contains data
------ ------
¦ box1 ¦ ¦ box2 ¦
------ ------
- Box1 shows inputed time in format hhnn (ex, 2215) and box2 has same
format.
I have already tried to put another textbox (box1a) that was not visible in
form view with default value 20 and format nn. Then on box2 i entered source
as: =[box1]-[box1a] but I didn't have apropriate result becaus calculation
dit not efected time but date in stead.
how should I resolve this situation.