MS Access System MSGBOX erorr message

[DJhang]

hey all,

i'm sorry.. im fairly beginning to get into MS Access in terms of VBA and I have some really easy and very noobish questions.

Hopefully someone nice enough can help me out..

I have an Access file that is pulling data in from 2 Excel files and i usually run a forum i customized every month and never had a problem and i make sure the formatting of the 2 Excel files are exactly the same.

However this month I got this error, I get a msgbox coming from MS Access with an exclamation saying "Division by Zero".

This happens on only a few of my forums configured but some of my other forums seems to be working just fine.. what does this error mean? i know it's an easy design fix i think.. if someone can help me find what i need to change and how i'd appreciate it.

thanks!
-david

[OBP]

david, it means exactly what it says, somewhere in the system something is being divided by zero, which is a complete "no no" with computers as it would send them in to an endless loop if they tried to do it, so they stop.
Are you doing any statistics on the forum results?
Can you show us what forum data produces the error message?

[DJhang]

thanks, i figured it out!


david, it means exactly what it says, somewhere in the system something is being divided by zero, which is a complete "no no" with computers as it would send them in to an endless loop if they tried to do it, so they stop.
Are you doing any statistics on the forum results?
Can you show us what forum data produces the error message?