Address label formatting question

[Guest]

I set up the labels using the format wizard (worked great!). The problem is
that whoever originally set up my customer database used an asterik in front
of the customer's name which I don't want printing on the address label. Is
there a function or expression I can write to have it remove the pesky *?!

Thanks,

 

[fredg]

I set up the labels using the format wizard (worked great!). The problem is
that whoever originally set up my customer database used an asterik in front
of the customer's name which I don't want printing on the address label. Is
there a function or expression I can write to have it remove the pesky *?!

Thanks,

Does every customer name have that asterisk? Or just some?
You can change the stored data by using an Update Query.
This will affect all your customer records.

Back up the table first.

Update YourTable Set YourTable.CustomerName =
IIf(Left([CustomerName],1)="*",Mid([CustomerName],2),[CustomerName]);