How do I move data in one column up one row

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am trying to make a database from another program. I copied the First
Name, Last Name, and Address. The Adresses' went into the column leaving a
blank cell at the top. I need to remove that cell so all the addresses' will
move up one row in order to match the first and last name. Hope I made this
easy to understand. Can someone tell me how to do this? Thank you
 
One fairly easy method would be to export the entire table to Excel (File -
Export).
Remove the unwanted cell, selecting "Move Up" when prompted.
Verify that the rows are now aligned as you desire.
Then import the whole thing back into Access.
 
I am trying to make a database from another program. I copied the First
Name, Last Name, and Address. The Adresses' went into the column leaving a
blank cell at the top. I need to remove that cell so all the addresses' will
move up one row in order to match the first and last name. Hope I made this
easy to understand. Can someone tell me how to do this? Thank you
Click to expand...

Access tables do not have "cells". Access Tables do not have "a first
record" or "a last record" or "a top" in any useful way.

Your Table apparently contains a record with Null in the Address
field, and all the other records have an incorrect address (the
address pertaining to a different record). I'd really suggest running
an Update query to update the Address field to NULL for all records,
and try again copying and pasting - or, better, running an update
query - to insert the correct addresses. There's no way to "move an
address up" because there is no "up" or "down".

John W. Vinson[MVP]
 
Thank you so much. I did what you said and it worked :)) I must have tried
for about an hour in access to do it and finally gave up and wrote this note.
I really appreciate your help and making it easy to do.
 
Back
Top