Results 1 to 2 of 2
2003-02-06, 15:23 #1
- Join Date
- Oct 2002
- New Salem, North Dakota, USA
- Thanked 0 Times in 0 Posts
Change Field size in a query (2000)
When creating a make table query......Is it possible to change the field size property in the query?
2003-02-06, 15:53 #2
- Join Date
- Mar 2002
- Thanked 29 Times in 29 Posts
Re: Change Field size in a query (2000)
No, field size is copied from the source fields. If you want the target fields to have a different size from the corresponding source fields, you must create an empty table with the desired field sizes first, and then use an append query instead of a make table query.
You can either create the empty table manually, or use a definition query for this, or use DAO code.
Definition queries have to be written in SQL, you can't display them in the query design grid. An example of the SQL for a definition query to create a table is
CREATE TABLE tblNames (LastName TEXT (30), FirstName TEXT (20), BirthDate DATETIME, CONSTRAINT MyKey PRIMARY KEY (LastName, FirstName));
This will create a table named tblNames with fields LastName, FirstName and BirthDate, and a primary key on the LastName/FirstName combination.