Re: Decimal fields's precision is too small to accept the numeric you attempted to add

Switch your Make Table query to SQL View (View menu in query design), copy
the SQL statement, and post it here.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Phil" <phil_at_nhs@xxxxxxxxxxx> wrote in message
news:eR%23Gi%23NOGHA.2884@xxxxxxxxxxxxxxxxxxxxxxx
Been there, done that. Tried to use double , didn't work. Did not use
the NZ, but everything has a zero or greater value. I can try it with it,
if you think it will make a difference....





Allen Browne wrote:
The error message in the subject indicates that JET is understanding the
source field as a Decimal type, with Scale and Precision.

JET has all sorts of trouble deailing with this data type.
Could you explicitly typecast the field into a Double or Currency?
For example, if the field is Field1, you could try:
SELECT CCur(Nz([Field1],0)) AS MyField, Field2, ...


.

Loading