calculating percentage! urgent

[cherrynich]

I am using filter by form to obtain the number of my work orders that are
complete, I need to take that number and divide it by the total number of
jobs and get my completion percentage to show up on the form. Any
suggestions??? I would very much appreciate it!

Thanks,
Nick Cherry

 

[John Vinson]

I am using filter by form to obtain the number of my work orders that are
complete, I need to take that number and divide it by the total number of
jobs and get my completion percentage to show up on the form. Any
suggestions??? I would very much appreciate it!

Well, given that I have no idea where in your tables or queries the
number of work orders might be found, I have to hazard a guess here...
but something like an expression such as

=DCount("*", "[WorkOrders]", "[Complete] = True") / DCount("*",
"[WorkOrders]")

as the Control Source of a form textbox might work. You may need to
add criteria to limit it to that subset of workorders of current
interest.

John W. Vinson[MVP]
Join the online Access Chats
Tuesday 11am EDT - Thursday 3:30pm EDT
http://community.compuserve.com/msdevapps