Doesn't Display Any Output

[Chinxster]

I am linking a table to an ODBC database we have here (MAS90). After I linked the table, I created a query that would display certain information such as sales order date, item number, quantity ordered, and dollar amount. For some reason when I try to open it, it loads up and then gives me an error box that says "The decimal's precision is too small to accept the numeric you attempted to add." I checked the linked table's properties to see what the precision was set at and I also checked the data that the query was reading. The data from the query does not violate the precision. Therefore, I don't understand why it cannot ouput the data in the query. I just set the precision to the highest which is 28. The data for sales order date, item number, quantity ordered, and dollar amount never exceeds 28 digits. I don't know what to do. Any help will be greatly appreciated. Thanks so much!!!!

Glendy

 

[Lushman]

Post the database and I'll see what I can do.

 

[Chinxster]

Can't output

Lushman,
I can't post the database because there is a firewall for our company computers. Our files cannot be used over the internet. Is there anyway you can help without looking at the database? Tell me what exactly you need to know so I can further assist you in my problem. I really appreciate your help. Thank you so much.

Glendy