Solved

Over Flow error

Posted on 2004-09-26
3
226 Views
Last Modified: 2010-04-17
while i execute my query i'm getting an over flow error. my query is:

select pname,sum(qty),sum((qty/amount)*qty)as price,amount from sales Group By pname

in my table some records qty and amount is zero. this situation i'm getting this overflow error. i'm using Access database. pls help me...
0
Comment
Question by:satdream
3 Comments
 
LVL 33

Expert Comment

by:hongjun
ID: 12153949
you cannot divide by zero.
0
 
LVL 4

Accepted Solution

by:
DaveyEss earned 50 total points
ID: 12154039
Put a where clause on that says "where amount <> 0" as you are dividing by zero sometime which is causing problems.

0
 

Author Comment

by:satdream
ID: 12154181
hi friends,
thanks to all....

SatDream
0

Featured Post

Announcing the Most Valuable Experts of 2016

MVEs are more concerned with the satisfaction of those they help than with the considerable points they can earn. They are the types of people you feel privileged to call colleagues. Join us in honoring this amazing group of Experts.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

A short article about a problem I had getting the GPS LocationListener working.
Entering a date in Microsoft Access can be tricky. A typo can cause month and day to be shuffled, entering the day only causes an error, as does entering, say, day 31 in June. This article shows how an inputmask supported by code can help the user a…
An introduction to basic programming syntax in Java by creating a simple program. Viewers can follow the tutorial as they create their first class in Java. Definitions and explanations about each element are given to help prepare viewers for future …

789 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question