# Thread: Diving a small number into a big number

1. Registered User
Join Date
Jul 2002
Posts
20

## Unanswered: Diving a small number into a big number

Hi there,

I wonder if anyone can help me. I have done a update query where i am dividing one row by another. Now it works fine dividing a bigger number into a small but when you do the opposite way(small into a big) it does not work and i get a 0 value, and unfortiunately i need to work out the calculations that way for my work. I would do it usually in excel but there is too much data to fit into on spreadsheet.l

So can someone here tell me what i am doing wrong as it it is driving me mad !

Cheers

2. Grand Poobah
Join Date
Sep 2003
Location
MI
Posts
3,713
1st try posting the query you're using ... Don't know what is wrong until we see it ...

3. Stuck on my opinions...
Join Date
Nov 2003
Posts
1,487
Ensure that you are using the correct data type for your solution (Single or Double).

.

4. Registered User
Join Date
Jul 2002
Posts
20

## I hope this helps

It would help wouldn't it lol

UPDATE DUAL_A_URBAN_INV SET DUAL_A_URBAN_INV.[Average 3] = [DUAL_A_URBAN_INV]![Average 2]/[DUAL_A_URBAN_INV]![Total];

An example would be 32(Average 2)/36789(Total)

5. Stuck on my opinions...
Join Date
Nov 2003
Posts
1,487
UPDATE DUAL_A_URBAN_INV SET DUAL_A_URBAN_INV.[Average 3] = CDbl([DUAL_A_URBAN_INV]![Average 2]/[DUAL_A_URBAN_INV]![Total]);

.

6. Registered User
Join Date
Jul 2002
Posts
20

## Sorted

It was that i was not using the correct data type it should of been double

Works like a dream now

Many thanks chaps !!

#### Posting Permissions

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