Solved

Over Flow error

Posted on 2004-09-26
3
228 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
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

[Live Webinar] The Cloud Skills Gap

As Cloud technologies come of age, business leaders grapple with the impact it has on their team's skills and the gap associated with the use of a cloud platform.

Join experts from 451 Research and Concerto Cloud Services on July 27th where we will examine fact and fiction.

Question has a verified solution.

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

Q&A with Course Creator, Mark Lassoff, on the importance of HTML5 in the career of a modern-day developer.
Part One of the two-part Q&A series with MalwareTech.
Viewers will learn how to properly install Eclipse with the necessary JDK, and will take a look at an introductory Java program. Download Eclipse installation zip file: Extract files from zip file: Download and install JDK 8: Open Eclipse and …
Starting up a Project

627 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