Calculate by a certain number in a series

H

HHoward

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
 
W

Wayne Morgan

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.
 
Top