Function Procedures

  • Thread starter Thread starter Laura
  • Start date Start date
L

Laura

I've a database that has a field derived from a
combination of two fields with calcuation formulas in
them. I am trying to get % completed based off of two
date fields with the result being a percentage. My
problem is that the % completed result on the report goes
beyond 100% as the formulas are using Date() as part of
their calculation. I would like to do an IF..Then...Else
statement to stop this from occurring. Would it be better
to change the two fields from formulas and use a Function
statement and then use the two fields in the
IF..Then...Else? Any suggestions?
 
Currently I have the fields setup like this:
I have one field that calculates Text229
=Date()-[contaward]
a second field that calculates percmpl
=([datecmpl]-[contaward])

Then I use them to give me the % completed to date =
[Text229]/[percmpl]
 
Back
Top