I still haven't solved my first problem but I have ordered this websites book and it is on the way. Hopefully that help me to learn what I am doing.

I need to gather ink toning time, and to do that I think I need to pull from two or possibly three different tables.

Ink Toning Time

PV_Department.DeptName - want it to to only select "press"

PV_Operation.OperationCode - want it to only select "31"

*Also, here is the weird part. When I went back and looked at how my other totals were gathered it looked something like this.

if {PM_CompanyOption.LabourTimeFormat} = 0 then
truncate({#GT2RunHours}/3600) +
    truncate({#GT2RunHours} - (truncate({#GT2RunHours}/3600) * 3600))/6000
else
({#GT2RunHours}/3600);

So, I wonder if I need that third table PM_CompanyOption.LabourTimeFormat to calculate the time spent?

Thank you, and I apologize for my ignorance. I am learning and my first step is finding out how to learn. I jumped in head first and am having trouble.

sum (({PV_JobCosts.LabourSecs})/3600) if ({PV_Department.DeptName}) ="Press"; and ({PV_Operation.Operationcode}) ="31"

i thought i was on to something with this one, but apparently,from the "if" onward it doesn't appear to be part of a formula.

got another passable formula that looks to be just what i wanted but it's just not giving me the right info

if ({PV_Department.DeptName})="Press" and ({PV_Operation.Operationcode})="31" then ((sum ({PV_JobCosts.LabourSecs}))/3600) else 0

btw i am just learning boolean logic and crystal syntax

Edited by JBrown.CM - 11 Apr 2011 at 9:49am