I'm using MS Access 2000. I have a small database to keep track of my lighthouse
collection. Right now it's only two columns. I'd like to add a third. I'd like
the new column to be the third column, that is, to the right of the others.
Every time I try to insert a column, it ends up on the far left or in between
the two existing columns. How do I add one on the right? Thanks.

<rfdjr1 [at] optonline.net> wrote

> I'm using MS Access 2000. I have a small database to keep track of my
> lighthouse
> collection. Right now it's only two columns. I'd like to add a third. I'd
> like
> the new column to be the third column, that is, to the right of the
> others.
> Every time I try to insert a column, it ends up on the far left or in
> between
> the two existing columns. How do I add one on the right? Thanks.

How are you going about adding the column? If I open a table in Design
View, the most convenient place to add a column (aka field) is at the bottom
of the list, and, when the record is opened, that will be at the extreme
right.

Larry Linson
Microsoft Access MVP

On Thu, 10 Jan 2008 00:19:09 GMT, "Larry Linson" <bouncer [at] localhost.not> wrote:

><rfdjr1 [at] optonline.net> wrote
>
>> I'm using MS Access 2000. I have a small database to keep track of my
>> lighthouse
>> collection. Right now it's only two columns. I'd like to add a third. I'd
>> like
>> the new column to be the third column, that is, to the right of the
>> others.
>> Every time I try to insert a column, it ends up on the far left or in
>> between
>> the two existing columns. How do I add one on the right? Thanks.
>
>How are you going about adding the column? If I open a table in Design
>View, the most convenient place to add a column (aka field) is at the bottom
>of the list, and, when the record is opened, that will be at the extreme
>right.
>
> Larry Linson
> Microsoft Access MVP
>

Thanks. Design View did it for me. I added the field.