update prices so the last digit will be 7

[way2many]

Hi,
how do I update all prices changing the last digit to 7 or whatever number I want?
Now prices are like this:
$23.54
$53.22
$99.99
--

I just need to update them to:
$23.57
$53.27
$99.97

Thanks

 

[Remou]

How about something on the lines of:

UPDATE Table SET Table.Field = Left([Field],Len([Field])-1)+0.07;

 

[PHV]

UPDATE yourTable
SET [price field] = CCur(Format([price field],"#.#")+0.07)

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[Remou]

PHV
I tried a solution similar to yours before posting. I think you will find that Format rounds.

 

[SkipVought]

way2many,


I notice that over the past 5 years, you have posted 51 threads and have received many good tips related to your stated needs. Yet, you have responded only ONCE, to
[blue]
Thank Tek-Tip Contributor
for this valuable post![/blue].

The Stars accomplish several important things.

First, it gives positive feedback to contributors, that their posts have been helpful.

Second, it identifies threads as containing helpful posts, so that other members can benefit.

And third, it identifies the original poster (that's YOU, BTW), as a grateful member, that not only receives, but is willing to give tokens of thanks.

Skip,
[sub]
Just traded in my old subtlety...
for a NUANCE![/sub]

 

[Remou]

SkipVought
That worked, but probably not in the way you expected! :-D

 

[SkipVought]

way2many,

What valuable post" did I do for you?

The stars are for any contributor that provides a "valuable post" with respect you your thread.

I have requested Tek-Tips Management to remove this little purple star.

Skip,
[sub]
Just traded in my old subtlety...
for a NUANCE![/sub]