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

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...
.

Relevant Pages

  • Re: Access 2000 Appending records to a table
    ... You need to figure out why the query is failing, if the fields are not set ... When you say 'it fails to append', ... or only do the append when you have full information. ... around this process of adding bogus data just to poplate the fields so ...
    (microsoft.public.access.security)
  • Re: PHP + MySQL + Queries that depend on each other?
    ... if echo mysql_error; ... If it fails, it will display the succeeded error. ... Should this procedure be done every time a query is done, or, ... or take down the server between queries. ...
    (comp.lang.php)
  • Re: query from form
    ... The following forces the type of test to be a string. ... I have a question about applying to this to a query within a report. ... The query that fails refers to the text box on the form. ...
    (microsoft.public.access.queries)
  • Re: Decimal fieldss precision is too small to accept the numeric you attempted to add
    ... Your test query, as is, works fine. ... Can't understand why the same expression does not work in MY query. ... Tried putting the Cdbl) around both of those, still fails. ... If they are queries, you may need to perform the typecasting in the lower queries. ...
    (microsoft.public.access.queries)
  • Re: Date not within range query
    ... When Name Autocorrect works it is nice. ... can cause problems and often fails to work. ... Now use that and your entities table to do an unmatched query. ... have no linked records that fall inside a date range. ...
    (microsoft.public.access.queries)