How do I control the size of fields in a query?

[Sillygirl]

This is probably a simple one - but I'm drawing a blank. I have a make table query.

SELECT tblP63Active.NAME, tblP63Active.APPL_DEPT, tblP63Active.APPL_CLASS, tblP63Active.A_R, tblP63Active.APPL_DATE, tblP63Active.CURR_SHIFT, " " AS TYPE, " " AS FILL INTO tblP63Export
FROM tblP63Active;

I want to control the size of the last 2 fields, TYPE and FILL. How do I specify this in the query?

Thanks!
SG

 

[dhookom]

I don't believe this is possible in any way with a Make Table query. You could pre-build the table and then append records. I would not try to insert a space into new records.

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]