have either a Calculated Expression or User Input

[Guest]

Good Day All,

I have a query that I am using to calculate hrs worked, but sometimes the
user needs to just enter a number of hrs if it was a random job.

I have MondayStart, Mondaystop, totalhrs(calculated). how can I set it ups
so that the user can manually enter a number into the totalhrs field for my
billing calculation?

Is this clear?

should I have separate fields for these two?

Thanks,

Brook

 

[John Vinson]

Good Day All,

I have a query that I am using to calculate hrs worked, but sometimes the
user needs to just enter a number of hrs if it was a random job.

I have MondayStart, Mondaystop, totalhrs(calculated). how can I set it ups
so that the user can manually enter a number into the totalhrs field for my
billing calculation?

Is this clear?

should I have separate fields for these two?

Thanks,

Brook

You could "push" the calculated TotalHrs into the textbox in the
AfterUpdate event of MondayStart and MondayStop.

(I hope you don't have table fields named Monday/Tuesday/Wednesday/...
start and stop!!)

John W. Vinson[MVP]

 

[Guest]

hello and sorry for the late reply...

thanks for the help...

Brook