Using Left to extract info

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

Guest

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!
 
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
(e-mail address removed)
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

extract 3 numbers from a string 0
Extract Specific Data 2
Extracting data from string 5
Extract first part of text string 1
Adding field to query 1
Extract part of text 5
Checking if data exists another table and, if yes, extracting a value 0
Access's 'Left' function not working properly 6

Back
Top