need help with queries to delete numbers

R

richardmiami

have table with 3883 records an I need a queries that will delete -4 numbers
to the right of five other number on a field sample 33139-1245
 
J

Jeff Boyce

It isn't clear if you want to alter the data, or only see the leftmost
portion.

Take a look at the Left() function in Access HELP.

Good luck

Jeff Boyce
<Access MVP>
 
T

t t via AccessMonster.com

create an update query and write it's update line as left([field];len(
[field])-4) and run query.

I hope it helps you
 
J

Jeff Boyce

If you are CERTAIN you want to only save the first 5, take a look at Left(),
and, as "tt" suggested, use an update query -- make a backup copy BEFORE you
start!

Good luck

Jeff Boyce
<Access MVP>
 
Top