Update Query Help

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

Guest

Hi, I have a table with 3 columns. I would like to delete the first 3
numbers in each record in the 'Account Number' column .i.e 000123456Y to
123456Y. Can anyone give me the criteria expression/code to do this. Thanks.
-Cheyenne
 
I suppose the column you need to update is a Text, then
Update tableName
Set columnName = Mid(columnName, 4)

HTH
 
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

Update Query Expression question 3
Access Dcount (multiple criteria) 3
Query Parameter using multiple options 0
Data Mismatch in Excel 2010 4
Query --> Populate table, keep table parameters 3
Create New Table/Column 1
need a "find a record" code 1
Query Criteria 2

Back
Top