Improve company productivity with a Business Account.Sign Up

x
?
Solved

Over Flow error

Posted on 2004-09-26
3
Medium Priority
?
233 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 200 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

What Kind of Coding Program is Right for You?

There are many ways to learn to code these days. From coding bootcamps like Flatiron School to online courses to totally free beginner resources. The best way to learn to code depends on many factors, but the most important one is you. See what course is best for you.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

When you see single cell contains number and text, and you have to get any date out of it seems like cracking our heads.
In real business world data are crucial and sometimes data are shared among different information systems. Hence, an agreeable file transfer protocol need to be established.
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…
Simple Linear Regression

595 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