My data table has extra spaces

[Jeff Crocker]

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!

 

[Reggie]

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

----------

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?

 

[Jeff Crocker]

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

 

[Reggie]

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

----------

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.