Results 1 to 6 of 6
  1. #1
    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. #2
    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 ...
    Back to Access ... ADO is not the way to go for speed ...

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

    .
    Environment:
    Self Taught In ALL Environments.....And It Shows!


  4. #4
    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. #5
    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]);

    .
    Environment:
    Self Taught In ALL Environments.....And It Shows!


  6. #6
    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
  •