Create another table with a select...
select b,a,d,c from table1 into table table2
What is the reason you are needing the physical order of the fields changed?
>Dear Sir,
>
>I created a table, entitled table1, with table designer.
>The fields are as follows
>
>
>a n(1)
>b c(1)
>c n(2)
>d n(1)
>
>
>I want to change field order programatically as follows
>
>
>b c(1)
>a n(1)
>d n(1)
>c n(2)
>
>
>Is it possible to chage field order programatically,
>if then please help me.
>
>Thanks in advance
Wayne Myers, MCSD
Senior Consultant
Forte' Incorporated
"The only things you can take to heaven are those which you give away" Author Unknown