Calculated Fields and Multiple Joins

An alternative approach would be to use the JobAsmbl table and use the fields TLESetupHours and TLEProdHours to calculate the estimated hours and TLASetupHours and TLAProdHours to calculate the actual hours.

Virginia Joseph
Deep Hole Specialists, LLC
vjoseph@...

--- In vantage@yahoogroups.com, "Brian W. Spolarich" <bspolarich@...> wrote:
>
> I'm wondering if anyone has done something like this, and if it will
> work as desired in a BAQ.
>
>
>
> One of my users wants a summary view of jobs with their standard hours
> and the actual hours. So I'm going to have to define summary fields in
> the BAQ with joins between JobHead and JobOper and JobHead and LaborDtl.
> Will this do what I want, or am I going to get duplicate data prior to
> the summary?
>
>
>
> I basically need to sum up, for each job, the number of hours in the
> related JobOper records to define the estimated hours for the job, and
> then the number of hours in the related LaborDtl records to get the
> actual. I could do this in a stored procedure, but not sure if I can do
> this in a BAQ so I could use a dashboard.
>
>
>
> -bws
>
>
>
> --
>
> Brian W. Spolarich ~ Manager, Information Services ~ Advanced Photonix /
> Picometrix
>
> bspolarich@...
> <mailto:bspolarich@...> ~ 734-864-5618 ~
> www.advancedphotonix.com <http://www.advancedphotonix.com>
>
>
>
>
>
> [Non-text portions of this message have been removed]
>
I'm wondering if anyone has done something like this, and if it will
work as desired in a BAQ.



One of my users wants a summary view of jobs with their standard hours
and the actual hours. So I'm going to have to define summary fields in
the BAQ with joins between JobHead and JobOper and JobHead and LaborDtl.
Will this do what I want, or am I going to get duplicate data prior to
the summary?



I basically need to sum up, for each job, the number of hours in the
related JobOper records to define the estimated hours for the job, and
then the number of hours in the related LaborDtl records to get the
actual. I could do this in a stored procedure, but not sure if I can do
this in a BAQ so I could use a dashboard.



-bws



--

Brian W. Spolarich ~ Manager, Information Services ~ Advanced Photonix /
Picometrix

bspolarich@...
<mailto:bspolarich@...> ~ 734-864-5618 ~
www.advancedphotonix.com <http://www.advancedphotonix.com>





[Non-text portions of this message have been removed]