C
cherrynich
I have a form I'm about to make, to calculate a percentage, I have a
parameter that asks for status, called status. I want the form to execute a
query that tells me the number of entries I have that match that criteria
divided by the number of not null fields in another column called work order
type. but before it does any of that i have 4 other parameters I want it to
sort through first, i have a beginning date and ending date and tech and
management area. could someone clue me in as to how to start with this?
parameter that asks for status, called status. I want the form to execute a
query that tells me the number of entries I have that match that criteria
divided by the number of not null fields in another column called work order
type. but before it does any of that i have 4 other parameters I want it to
sort through first, i have a beginning date and ending date and tech and
management area. could someone clue me in as to how to start with this?