Calculate by a certain number in a series

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

Guest

I have a field that I want to have multiplied by the second two number in a
four number series that my user enters.

For example

Standard hours * The second two numbers in the week number entered by the user

Standard hours = 40 * User entered week = 7114

40 * 14

Total should be 560

Field names are [Stndhrs] and [WEEK] =[Enter Week No.]

Thanks for the help
 
If it is always the last 2 digits,

Standard Hours = 40 * Right([Enter Week No.], 2)

If the format of the number can vary, we will need to know the possible
variations.
 
Back
Top