How to Modify Data in fields to conform formatting requirements?

[Gilbert Noetzel]

Hey people..it's me again.. I need to get Access to change a data field.

I have a chart of accounts from DB2 system and I need to append the
description fields as an example below:

CHRTDES ="Expnese Paid "
CHRTDES =" - Comp.Fees"

Above example is I want to remove the (space,space,hyphen,space) so that
the field description result would be

CHRTDES ="Comp.Fees"

I am now going through the ACCESS Bible book but I would appreciate any
input if you have any.

thanks in adavance

Gil

 

[Gilbert Noetzel]

I know I can use the Find/Replace in the Table Menu, but is there a way
to insert a expression or script of some sort to automate this task?

Gil

 

[Guest]

Have you tried using an Update query?