Adding a new row

  • Thread starter Thread starter Yung
  • Start date Start date
Y

Yung

Dear all,

I have a table as below:

Column1 Column2
------- -------
abc 1
bbc 2
ccd 3

What I want to do is when column2 = 2, then access add
one blank row below it, if column2 = 3, then access add 2
blank rows.. etcetc..

Would anyone tell me how should I code it inorder to
achieve this purpose?

Thanks in advance.
 
Dear all,

I have a table as below:

Column1 Column2
------- -------
abc 1
bbc 2
ccd 3

What I want to do is when column2 = 2, then access add
one blank row below it, if column2 = 3, then access add 2
blank rows.. etcetc..

Would anyone tell me how should I code it inorder to
achieve this purpose?

Thanks in advance.
Click to expand...

Blank rows in an Access table simply make no sense. A Table is NOT A
SPREADSHEET; it's an unordered "bag" of data. If you had six blank
rows in the table, they would all be identical, and would not be
associated in any way with the abc or ccd records.

Could you explain what business task you're trying to accomplish? I'm
sure there's a better way!
 
Ok, actually what I was trying is like this:

Column1 Column2 Column3
------- ------- -------
abc 1 123
bbc 2 234
ccd 3 345

When Column2 is 2, then access add 1 row below it by
copying column1, column2 n in column3, it changed
to "000", if it is a 3, then add 2 rows n changed column3
to "000" as above..

Can anyone have an idea? Its kinda updating.. but dont
know how to make it.
 
Ok, actually what I was trying is like this:

Column1 Column2 Column3
------- ------- -------
abc 1 123
bbc 2 234
ccd 3 345

When Column2 is 2, then access add 1 row below it by
copying column1, column2 n in column3, it changed
to "000", if it is a 3, then add 2 rows n changed column3
to "000" as above..

Can anyone have an idea? Its kinda updating.. but dont
know how to make it.
Click to expand...

I really don't understand what you're saying. Could you type in what
you want the above table to look like after this query? and, more
importantly - again - explain what you are trying to accomplish?
Adding these duplicate records SHOULD NOT BE NECESSARY.
 
Back
Top