have either a Calculated Expression or User Input

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
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
Click to expand...

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]
 
Back
Top