I have a question about using a function in a form

S

scubadiver

I have used the "workingdays2" function in a query to calculate the number
of working days between two days like so...

WorkingDays2([SLA_Date3],[SLA_Date4])

I have tried using this in a text box in a form but the calculation won't
work.

Any ideas?
 
S

SteveM

So I assume WorkingDays2() is a user-defined public function?
SLA_Date3 and SLA_Date4 are fields on your form?

Try putting = sign first:

=WorkingDays2([SLA_Date3],[SLA_Date4])

Steve
 
S

scubadiver

Another stupid moment. Date4 was earlier than Date3, duh!




SteveM said:
So I assume WorkingDays2() is a user-defined public function?
SLA_Date3 and SLA_Date4 are fields on your form?

Try putting = sign first:

=WorkingDays2([SLA_Date3],[SLA_Date4])

Steve

scubadiver said:
I have used the "workingdays2" function in a query to calculate the number
of working days between two days like so...

WorkingDays2([SLA_Date3],[SLA_Date4])

I have tried using this in a text box in a form but the calculation won't
work.

Any ideas?
Click to expand...
Click to expand...
 
Top