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

Copying down a column in Microsoft Access

P: n/a
Hi,
I'm new to Microsoft Access today, so this is probably a very basic
question for all you clever people out there.

Anyone know how I copy down a column in Microsoft Access? It doesn't
seem to have the same functionality as Excel, i.e. I can't just write
in one cell and then drag this down or highlight a whole column and
have the contents of that cell reappear in every cell I've highlighted.

heeeeelp........

Nov 13 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
On 28 Oct 2005 11:02:20 -0700, Ratnest wrote:
Hi,
I'm new to Microsoft Access today, so this is probably a very basic
question for all you clever people out there.

Anyone know how I copy down a column in Microsoft Access? It doesn't
seem to have the same functionality as Excel, i.e. I can't just write
in one cell and then drag this down or highlight a whole column and
have the contents of that cell reappear in every cell I've highlighted.

heeeeelp........


The very basic answer is the you never, ever work in Table View.
If you create a form for data entry, you can copy the value in a field
(it's a field not a cell) from the last record viewed to the next one
by clicking Ctrl + ' in that field while you are in that next record.

It's time to get away from thinking Excel and start thinking Access.

You can also fill fields with a value using a query or code, but since
I have no idea what you are doing, I'll leave you here.
--
Fred
Please respond only to this newsgroup.
I do not reply to personal e-mail
Nov 13 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.