Decimal fields's precision is too small to accept the numeric youattempted to add

[Phil]

Using Jet engine version from WINXP SP2

I have a simple query which:

Works as a select query. Fails as a make table, fails as an append, and
fails if referenced by another query.

A little help would be appreciatied...