Results 1 to 3 of 3
  1. #1
    Lounger
    Join Date
    Apr 2008
    Location
    Jacksonville, North Carolina, USA
    Posts
    37
    Thanks
    0
    Thanked 0 Times in 0 Posts

    query overflow problem (access 2003)

    Good morning all hope everyone is doing well
    Here is my problem today I have the following formula in a query and when I run it I get overflow what does that mean. If I add it the formula works if I subtract it it works and if i multiply it it works but when I try to divide it it says overflow. Thank you in advance for your help with this problem Here is the formula O & MLife: ([AC TOT FP FY10]*[Item Cost FY 10])/[Est Life in Years]

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: query overflow problem (access 2003)

    What are the data types and field sizes of the three fields involved in the formula?

  3. #3
    Lounger
    Join Date
    Apr 2008
    Location
    Jacksonville, North Carolina, USA
    Posts
    37
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: query overflow problem (access 2003)

    Thanks Hans I went back threw did some troubleshooting and realized I had a zero in a couple of spaces. It works like a charm know. Thanks again for the help.

Posting Permissions

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