expressions! please help me.

C

cherrynich

I have two queries off of one table. query1 calculates how many work orders
there are between two dates in the table, query2 calculates the number of
statused completions, cancellations, holds or reschedules, depending upon
which one I choose from a drop list. I want to calculate the the number of
results in query2 over the number of results in query 2, to make a
percentage. How do I even attempt this in an expression I'm sure but how??
please help me I need to do this and it seems as though it should be easy.
 
M

Mike Labosh

I have two queries off of one table. query1 calculates how many work orders
there are between two dates in the table, query2 calculates the number of
statused completions, cancellations, holds or reschedules, depending upon
which one I choose from a drop list. I want to calculate the the number
of
results in query2 over the number of results in query 2, to make a
percentage. How do I even attempt this in an expression I'm sure but
how??
please help me I need to do this and it seems as though it should be easy.
Click to expand...

Write a Query3 so that it joins Query1 and Query2 on some meaningful column,
and performs the calculations you need.

--
Peace & happy computing,

Mike Labosh, MCSD

"It's 4:30 am. Do you know where your stack pointer is?"
 
Top