Using Left to extract info

T

Tara

I have a set of DFC case numbers that can be of varying length. I need to
extract everything except the last 2 digits. I know I can use the left
function, but I've never done it. What would the criteria structure look
like?

Thanks!
 
S

Steve

Actually you want to use the Left and Len functions. Look these up in the
Help file. Your expression would be:

Left([DFCCaseNumber],Len([DFCCaseNumber])-2)

PC Datasheet
Providing Customers A Resource For Help With Access, Excel And Word
Applications
[email protected]
 
Top