# Thread: Query formulae help wanted (Office 2000)

1. ## Query formulae help wanted (Office 2000)

Hi guys,
How can I do the following on a query?
If the currency (tccy) is equal to GBP then move the decimal point two places to the left.
For example if the price is 752 and the currency is GBP then the price becomes 7.52.
Can anyone help me with the formulae??

2. ## Re: Query formulae help wanted (Office 2000)

Hi,
Use something like:
iif([tccy]="GBP",[price]/100,[price])
Hope that helps.

3. ## Re: Query formulae help wanted (Office 2000)

Add a new column to the query and put this in the top line:

NewPrice: IIf([tccy]="GBF",[Price]*0.01,[Price])

This will work to display the 752 as 7.52 but will not change the 752 that is stored in the table.

hth,
Jack

4. ## Re: Query formulae help wanted (Office 2000)

Thank you Rory & Jack.
The formulae works well.
Thanx again.
<img src=/S/bow.gif border=0 alt=bow width=15 height=15> <img src=/S/kiss.gif border=0 alt=kiss width=34 height=15> <img src=/S/smile.gif border=0 alt=smile width=15 height=15>

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts
•