Can this be done?

[Lori]

I've created tables queries and reports to generate an invoice, everything is
working perfectly. The one issue I have is that on our projects 10% of the
total invoice is held as retention until the job is 50% complete. I have the
invoice working perfectly, with the 10% so here is my question.

Once the project reachs 50% the retention drops to 5%, how would I write the
expression so that the invoice will include the 5% retainage difference in
the total for the current bill.

I have the following fields: Contract Value, Previously Billed, Current
Billed, Total Completed to Date, Percentage Complete and Retention Held.

Any help would be appreciated.

 

[scubadiver]

How do you record when a job is half complete? That should simplify things a
bit.

 

[Lori]

These are fields in the report: Contract Value, Current Billing, Previous
Billed; Total Billed to Date; Percentage Complete and then the retention,
which calculates 10% of the Billed to date.

 

[John Spencer]

It would help if you posted what you were using. You might be able to use

IIF([Percentage Complete]< .5,.1 * [Contract Value],
IIF(Percentage Complete]<1, .05 * [Contract Value], 0))

as a calculated field.



'====================================================
John Spencer
Access MVP 2002-2005, 2007
Center for Health Program Development and Management
University of Maryland Baltimore County
'====================================================