Over Flow error

Posted on 2004-09-26
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...
Question by:satdream
LVL 33

Expert Comment

ID: 12153949
you cannot divide by zero.

Accepted Solution

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.


Author Comment

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


Featured Post

Windows Server 2016: All you need to know

Learn about Hyper-V features that increase functionality and usability of Microsoft Windows Server 2016. Also, throughout this eBook, you’ll find some basic PowerShell examples that will help you leverage the scripts in your environments!

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Specific format 21 198
word0 challenge 4 68
object oriented design (python) and documentation tools 2 42
SQL Insert parts by customer 12 34
This article will show, step by step, how to integrate R code into a R Sweave document
Displaying an arrayList in a listView using the default adapter is rarely the best solution. To get full control of your display data, and to be able to refresh it after editing, requires the use of a custom adapter.
In this fourth video of the Xpdf series, we discuss and demonstrate the PDFinfo utility, which retrieves the contents of a PDF's Info Dictionary, as well as some other information, including the page count. We show how to isolate the page count in a…
With the power of JIRA, there's an unlimited number of ways you can customize it, use it and benefit from it. With that in mind, there's bound to be things that I wasn't able to cover in this course. With this summary we'll look at some places to go…

778 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