I have a question about using a function in a form

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
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
 
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...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

A question about field calculations 3
I have a strange data mismatch error 4
How can I calculate working days between dates? 1
Using a New Function in a Query 17
#Error in Results 4
Argument problem 13
Need help with code... 7
How to use a function in a query 1

Back
Top