By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
425,635 Members | 913 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 425,635 IT Pros & Developers. It's quick & easy.

Adding a column

P: n/a
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.

Jan 9 '08 #1
Share this Question
Share on Google+
2 Replies


P: n/a
<rf****@optonline.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
Jan 10 '08 #2

P: n/a
On Thu, 10 Jan 2008 00:19:09 GMT, "Larry Linson" <bo*****@localhost.notwrote:
><rf****@optonline.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.

Jan 10 '08 #3

This discussion thread is closed

Replies have been disabled for this discussion.