My data table has extra spaces

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

Guest

How can I get rid of extra blank spaces or cells in my columns? if I have a column with 26 numbers in it and the next column has letters "a b c d & f" in the column.

the data will display 1-26 correctly but the column with the letters will display
a in cell 1, b in cell 2, c in cell 3, and d in 4, but will add a blank cell in and then display f in cell 6 . I have tried to sort etc. and cant lock the data. if I add an age column to say 65yrs old it really messes up all the other data. Can anyone help me?

Thanks Jeff!
 
Jeff, Each column does it's sort first then moves to the next column from
left to right and so forth. It will not split up a row of data and place one
value from a record next to a different record. Each record is store as a
whole object. For instance if you had a table of employees and their
salaries you wouldn't want to sort by employee name field, lock that column,
then have access(or any other program) re-associate the salary with another
employee.
--
Reggie

----------
Jeff Crocker said:
How can I get rid of extra blank spaces or cells in my columns? if I have
Click to expand...
a column with 26 numbers in it and the next column has letters "a b c d & f"
in the column.
the data will display 1-26 correctly but the column with the letters will display
a in cell 1, b in cell 2, c in cell 3, and d in 4, but will add
Click to expand...
a blank cell in and then display f in cell 6 . I have tried to sort etc.
and cant lock the data. if I add an age column to say 65yrs old it really
messes up all the other data. Can anyone help me?
 
Thank you for your help. by locking the column do you mean using the freeze feature?, the content still got shuffled. I have since rebult the table but would like to learn how to do this, locking feature.

Jeff
 
Jeff, what I was referring to when I said locking was you wouldn't want to
sort by column A for example, lock the data in that sort order for column A
then move over to column B and sort by that column while keeping column A in
it's sorted order. I was only using this as an example and it is not
possible to do this in access.

--
Reggie

----------
Jeff Crocker said:
Thank you for your help. by locking the column do you mean using the
Click to expand...
freeze feature?, the content still got shuffled. I have since rebult the
table but would like to learn how to do this, locking feature.
 
Back
Top