By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,191 Members | 1,064 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,191 IT Pros & Developers. It's quick & easy.

Overflow in Ms Access

P: 1
In using Ms Access 2002 running on XP Pro O/S. I have a report made from a query that has two linked tables. There are calculations in the report (set up in the query) and when I run the report in get a message that reads Overflow.

There is no other message and no indication of where the problem begins.

I do not have any VB code, but I am using some Access generated commands to count the records - (the = 1) function.

Any suggestions of where to look for the error will be greatly appreciated.

Jose Ruiz
May 18 '07 #1
Share this Question
Share on Google+
2 Replies


ADezii
Expert 5K+
P: 8,638
In using Ms Access 2002 running on XP Pro O/S. I have a report made from a query that has two linked tables. There are calculations in the report (set up in the query) and when I run the report in get a message that reads Overflow.

There is no other message and no indication of where the problem begins.

I do not have any VB code, but I am using some Access generated commands to count the records - (the = 1) function.

Any suggestions of where to look for the error will be greatly appreciated.

Jose Ruiz
Post your Query Calculations.
May 19 '07 #2

missinglinq
Expert 2.5K+
P: 3,532
Dividing zero by zero (0/0) and stuffing the results of a calculation into a numeric data type that is too small to hold it are two common reasons for this error.
May 19 '07 #3

Post your reply

Sign in to post your reply or Sign up for a free account.