Any way to specify a field width of the resultant table in my Make-Table query? I want to run it repeatedly as new data arrives in another table, so editing the resultant table is a poor option.
Even though "Trench" is width 12 in my original table, it becomes width 50 in my new table, where it is now called "Name". I have also tried to set the Tools>Options default text field width to 12, which had no effect.
Here is a sample of my query. Any suggestions appreciated, thanks.
SELECT [MNTRASSH].["TRENCH"] AS Name INTO TRH_A2_ForLayout
FROM [Trench Location LUT] INNER JOIN (MNTRASSH INNER JOIN Signif ON MNTRASSH.["TRENCH"] = Signif.Name) ON [Trench Location LUT].Name = MNTRASSH.["TRENCH"]
WHERE ((([Trench Location LUT].Location)="Area 2"));
Even though "Trench" is width 12 in my original table, it becomes width 50 in my new table, where it is now called "Name". I have also tried to set the Tools>Options default text field width to 12, which had no effect.
Here is a sample of my query. Any suggestions appreciated, thanks.
SELECT [MNTRASSH].["TRENCH"] AS Name INTO TRH_A2_ForLayout
FROM [Trench Location LUT] INNER JOIN (MNTRASSH INNER JOIN Signif ON MNTRASSH.["TRENCH"] = Signif.Name) ON [Trench Location LUT].Name = MNTRASSH.["TRENCH"]
WHERE ((([Trench Location LUT].Location)="Area 2"));
