Replace chars

[Guest]

I am trying to replace chars in field without replacing all the chars. I
have a field called in Member TBL called MbrName with a value of BFL####. I
need to run a query that promps for a user number and have the #### replaced
with the user number entered. I can only get the entire value replaced.
help!

 

[Guest]

Steve,

Is 'BFL' part of every MbrName value (interesting name for a field that is
clearly not a member name)? Why not simply catenate 'BFL' to the beginning of
the number in the update (presumably) SQL. Like:

update MemberTBL set MbrName = "BFL" & Str([What's the number? ])
where <whatever the criteria are to limit the update to this
single record>;

Or am I completely missing your problem here?

 

[Andre Laplume via AccessMonster.com]

This should work...

Create an Update Query and drop down MbrName. Under the condition put:
LEFT([MbrName],3) = "BFL"


Under Update put: "BFL" & [Enter the new number]


It should change any member number staring with: BFL to BFL + the number
you enter.

 

[Guest]

Sorry I wasnt so clear. The MbrName field will have many different members
that will have #### in then name that will need to be replaced with the user
number entered. I have created a standard Table of members that will be
loaded to a second table after the update is applied. It's basically a model
list that the user imports into prod table.

Steve,

Is 'BFL' part of every MbrName value (interesting name for a field that is
clearly not a member name)? Why not simply catenate 'BFL' to the beginning of
the number in the update (presumably) SQL. Like:

update MemberTBL set MbrName = "BFL" & Str([What's the number? ])
where <whatever the criteria are to limit the update to this
single record>;

Or am I completely missing your problem here?

I am trying to replace chars in field without replacing all the chars. I
have a field called in Member TBL called MbrName with a value of BFL####. I
need to run a query that promps for a user number and have the #### replaced
with the user number entered. I can only get the entire value replaced.
help!