I'm running a create table query - "numeric field overflow" error

=?Utf-8?B?Z3JhbmFkYTc1MDY3?=

Guest

Posts: n/a

24th Feb 2005

In access, I'm trying to run a create table query in Access and it will run
smoothly the first time I run it, but when I try to run it more than once
without editing anything, I get a numeric field overflow error. Most fields
in the table are text, but one field is a date and one is currency. I don't
know if that will effect it.

« Mutiple Field Crosstab | Merging Access to Word »

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads You may not post replies You may not post attachments You may not edit your posts BB code is On Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are Off Forum Rules

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Query that calls value from one table field to another table field	Lisa W.	Microsoft Access Queries	4	10th Dec 2007 05:51 PM
Make Table Query-Running a make table query before you open a for	=?Utf-8?B?dGtpcmNob2ZmMTU=?=	Microsoft Access Macros	4	13th Apr 2007 11:50 PM
To have month and year as part of the table name in CREATE TABLE or MAKE TABLE Query	ichew@scs.com.sg	Microsoft Access Getting Started	1	18th Apr 2006 06:38 AM
Create Table Primary Key after Make Table Query And Update Table	=?Utf-8?B?Uk5VU1pAT0tEUFM=?=	Microsoft Access Queries	1	3rd May 2005 08:07 PM
Create table with field names based on the value of a field in another table.	simon_minder@hotmail.com	Microsoft Access Database Table Design	5	24th May 2004 02:32 PM