Adding a column

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.

Re: Adding a column

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

Re: Adding a column

On Thu, 10 Jan 2008 00:19:09 GMT, "Larry Linson" wrote:

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