Adding a column

[rfdjr1@optonline.net]

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.

[Larry Linson]

Re: Adding a column

<rfdjr1@optonli ne.netwrote

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

[rfdjr1@optonline.net]

Re: Adding a column

On Thu, 10 Jan 2008 00:19:09 GMT, "Larry Linson" <bouncer@localh ost.notwrote:

><rfdjr1@optonl ine.netwrote
>

>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.