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

How to improve team productivity

Quip adds documents, spreadsheets, and tasklists to your Slack experience
- Elevate ideas to Quip docs
- Share Quip docs in Slack
- Get notified of changes to your docs
- Available on iOS/Android/Desktop/Web
- Online/Offline

Join & Write a Comment

Suggested Solutions

Title # Comments Views Activity
copyEvens challenge 6 63
java continue statement 10 74
sumDigits  challenge 7 62
Adding Namespace to the second node of the xml 16 35
RIA (Rich Internet Application) tools are interactive internet applications which have many of the characteristics of desktop applications. The RIA tools typically deliver output either by the way of a site-specific browser or via browser plug-in. T…
Although it can be difficult to imagine, someday your child will have a career of his or her own. He or she will likely start a family, buy a home and start having their own children. So, while being a kid is still extremely important, it’s also …
In this fifth video of the Xpdf series, we discuss and demonstrate the PDFdetach utility, which is able to list and, more importantly, extract attachments that are embedded in PDF files. It does this via a command line interface, making it suitable …
In this seventh video of the Xpdf series, we discuss and demonstrate the PDFfonts utility, which lists all the fonts used in a PDF file. It does this via a command line interface, making it suitable for use in programs, scripts, batch files — any pl…

746 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

Need Help in Real-Time?

Connect with top rated Experts

16 Experts available now in Live!

Get 1:1 Help Now