How to copy content of one field to a range of other fields

  • Thread starter Thread starter Wim van Dongen
  • Start date Start date
W

Wim van Dongen

Hi,

I have a newbie question: is there a simple way to copy the content of one
field to a range of other fields in the same table?
Example: I need to copy the content of the sixth field of record number 10
to the sixth field of the records 400 until 600 and the content of the sixth
field of record number 15 to the sixth field of the records 601 until 800
and so on; a simple copy and paste routine would save me a lot of time, but
I understand that Access allows only the copying of the content of one field
to one other field, or am I wrong?

Any help would be appreciated very much

TIA

Wim
 
Hi,

I have a newbie question: is there a simple way to copy the content of one
field to a range of other fields in the same table?
Click to expand...

An update query.

BUT... storing data redundantly is generally VERY BAD DESIGN and
unnecessary.
Example: I need to copy the content of the sixth field of record number 10
to the sixth field of the records 400 until 600 and the content of the sixth
field of record number 15 to the sixth field of the records 601 until 800
and so on; a simple copy and paste routine would save me a lot of time, but
I understand that Access allows only the copying of the content of one field
to one other field, or am I wrong?
Click to expand...

Quite wrong... well, you're correct in that "copy and paste" works
field by field, but then "copy and paste" is almost never the best way
to move data around.

You also have a serious misconception. Access DOES NOT HAVE RECORD
NUMBERS. A Table is an unordered "bag" of data. There is no 400th
record!

I think you need to stop, step back, and reconsider your table design.
The whole POINT of using a relational database is that you avoid
storing duplicate data. Could you explain the structure of this table
and how this data is to be used?
 
Back
Top