add cell in table

[rrupp]

I just need to align the data in a column with the rest of the columns, so
the data field becomes a part of the record. I was wondering if there is an
insert cell function. For example, the information in field 2 with ID 432
needs to be in the next row. In Excel, you just insert a row and it works.
Any ideas?

ID Field1 Field2 Field3 Field4 Field5 Field6 Field7
432 0 334055
433 45655 5509602 000311 7/16/2008 INV PAID

 

[BruceM]

In Access you do your formatting in forms and reports. Tables are not
spreadsheets, and cannot be made to behave as if they were. They do not
have cells, and the order is irrelevant. If you want the look of a table
you can use the datasheet view of a form.

Your question about aligning is not clear, perhaps in part because I am not
seeing in my newsreader what you intended. Another problem is that it is
difficult to answer a question in the abstract. Some information about what
you are trying to do may help somebody suggest a solution. Are you saying
you want to combine the first record (432) with the second one (433), or
what exactly?

 

[rrupp]

BruceM -
My apologies for not being more exact in what I'm needing.

I need the data in Field 2 to move down one cell. I need this throughout
the entire table. So, yes, combining the data would make sense and I need it
for the whole table. In Excel you can just insert and move the cells down
one. I don't see an option to do that in Access. You have explained to me
that tables do not function as in Excel. Thank you, I appreciate you
explaining it to me.

Do you know of a way to move the data as in Excel when you insert and move
the cells down one? Can this be done in a form?? Am I explaining this
better?

Again, thanks for your time.

 

[Piet Linden]

BruceM -
My apologies for not being more exact in what I'm needing.  

I need the data in Field 2 to move down one cell.  I need this throughout
the entire table.  So, yes, combining the data would make sense and I need it
for the whole table.  In Excel you can just insert and move the cells down
one.  I don't see an option to do that in Access. You have explained tome
that tables do not function as in Excel.  Thank you, I appreciate you
explaining it to me.

Do you know of a way to move the data as in Excel when you insert and move
the cells down one?  Can this be done in a form??  Am I explaining this
better?

No, the only way to control order in a form is by sorting the data.
Period.

 

[KARL DEWEY]

You can update a record with data from another but you should always do a
backup before doing an update.

 

[BruceM]

As has been pointed out, you need to use a form (or report). In any case,
the order has to be determined by something. In Excel you can arrange rows
in an arbitrary order. In Access the data are ordered. They cannot be
arranged arbitrarily. There is no "in between" in a table. New records
appear at the bottom of the table.

Access table rows are typically referred to as records, and columns are
fields. A record is the various information about an entity. For instance,
a personnel table has fields for FirstName, LastName, Address, and so forth
(attributes of the entity, in this case a person). Together these fields
comprise a person' record. If you copied from a printed list to create a
personnel table, and messed it up so that Bob's city appears in Angela's
record, you either need to change the information one record at a time or
devise a query or other code to correct the information. You cannot insert
a cell in the City field and push all of the city information from that
point onward to the next row as you can with Excel.

Perhaps with some understanding of the actual situation it would be possible
to suggest a solution, but in the abstract this is the most I can suggest.

 

[Hans Up]

I need the data in Field 2 to move down one cell. I need this throughout
the entire table. So, yes, combining the data would make sense and I need it
for the whole table. In Excel you can just insert and move the cells down
one. I don't see an option to do that in Access. You have explained to me
that tables do not function as in Excel. Thank you, I appreciate you
explaining it to me.

Do you know of a way to move the data as in Excel when you insert and move
the cells down one?

Make a backup of your database in case anything goes wrong.

Export your Access table to Excel.

Rename or delete the Access table.

Manipulate the worksheet in Excel as you described.

Import the worksheet back in to Access as a new table.