need help with queries to delete numbers

[Guest]

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

 

[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 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

 

[Guest]

actually I need to delete the 5 numbers atfter the first 5

Thank you

 

[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>