G Guest Mar 9, 2006 #1 How can I set the field size at the time I do a make table query, not after the table is made?
T Tom Ellison Mar 9, 2006 #2 Dear Sierra: Maketable queries give you very little control. This is one of the things they don't do. Most advanced developers do not use maketable queries at all. Create the table the way you want it. Clear out any previous contents. Then use an append query. That gives you control. Tom Ellison
Dear Sierra: Maketable queries give you very little control. This is one of the things they don't do. Most advanced developers do not use maketable queries at all. Create the table the way you want it. Clear out any previous contents. Then use an append query. That gives you control. Tom Ellison
G Guest Mar 10, 2006 #3 Understood, thanks! Tom Ellison said: Dear Sierra: Maketable queries give you very little control. This is one of the things they don't do. Most advanced developers do not use maketable queries at all. Create the table the way you want it. Clear out any previous contents. Then use an append query. That gives you control. Tom Ellison Click to expand...
Understood, thanks! Tom Ellison said: Dear Sierra: Maketable queries give you very little control. This is one of the things they don't do. Most advanced developers do not use maketable queries at all. Create the table the way you want it. Clear out any previous contents. Then use an append query. That gives you control. Tom Ellison Click to expand...