I have a question about using a function in a form

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

scubadiver - 09 Jul 2007 15:50 GMT

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?

Reply to this Message

SteveM - 09 Jul 2007 16:32 GMT

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

> I have used the "workingdays2" function in a query to calculate the number
> of working days between two days like so...
[quoted text clipped - 5 lines]
>
> Any ideas?

Reply to this Message

scubadiver - 10 Jul 2007 09:20 GMT

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

> So I assume WorkingDays2() is a user-defined public function?
> SLA_Date3 and SLA_Date4 are fields on your form?
[quoted text clipped - 14 lines]
> >
> > Any ideas?

Reply to this Message