How do I delete the right 11 values in a field in access?

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

Guest

What is the statement I would need to write to delete the right 11 values in
a field in access?
 
try this to get the left chr minus 11


Left([FieldName],Len([FieldName])-11)
 
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

Setting values over multiple records in one Query using Loop statement 1
Windows 11 Windows 11 update 5
Populating a combo box's values based on another field's value (data entry) 1
Can you use query fields as function variables? 6
Transposing data in Access 2007 Query 1
Computational Photography in iphone 11 6
Lost in time! 5
Can't query datetime field formatted as m/d/yyyy 1

Back
Top