Two Access questions

[Anna]

Hi - I am using Access 2003.

1. I have a column with last name, first name - I want to remove the comma.
Can I do this and if so, how?

2. I have a few fields formatted as currency - USD. Now I find I have other
countries' currencies that need to appear in this field. If I change the
currency field to text what does this do to the currency that has already
been added?

Thanks!

 

[mscertified]

(1) Replace(MyCcolumn,',','')
(2) Don't know but why not make a copy of your table and try it (you learn
by trying things). I think you need the 'type-of-currency' in a separate
column.

-Dorian

 

[KARL DEWEY]

Remember if you make it text you will not be able to perform math unless you
convert it back again to a number.

 

[Arvin Meyer [MVP]]

Hi - I am using Access 2003.

1. I have a column with last name, first name - I want to remove the
comma.
Can I do this and if so, how?

Ideally, you should have 2 fields for first and last name. It is a violation
of Normalization rules to build non-decomposable fields. That said, I've
seen it used more times than I can count. By removing the comma, you do make
it slightly more difficult to separate them later, should you wish to. If
you are still insterested in removing the comma, the easiest way to remove
it is to use Find and Replace from the Edit menu on that column. You can
also write an Update query using the Replace() function.

2. I have a few fields formatted as currency - USD. Now I find I have
other
countries' currencies that need to appear in this field. If I change the
currency field to text what does this do to the currency that has already
been added?

In this case you definitely DO NOT want to change the datatype to text.
Change it to a Double, if you do not want the dollar sign to show, or,
because a currency field is more accurate than a Double, you may just want
to Format the field without a currency sign. Add a field to display the
country the currency is from so that you can still do math on the currency
field.

 

[Tom Wickerath]

Hi Anna,

You've already gotten enough replies for your first question, but I have
something that you may find helpful for your second question. Take a look at
this thread from last year:

http://groups.google.com/group/micr..._frm/thread/2323ff20e17158fe/b007dc2eeabdb2f7

In message #4, I show a way of displaying the correct currency format for
all records in a subform, where the country code is displayed in a field on
the main form.


Tom Wickerath
Microsoft Access MVP
http://www.accessmvp.com/TWickerath/
http://www.access.qbuilt.com/html/expert_contributors.html
__________________________________________