If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
My data table has extra spaces
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! |
#2
|
|||
|
|||
My data table has extra spaces
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" wrote in message ... 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! |
#3
|
|||
|
|||
My data table has extra spaces
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 |
#4
|
|||
|
|||
My data table has extra spaces
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" wrote in message ... 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 |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Updating Data in Linked Table w/Form | SeniorTrans | Using Forms | 0 | June 22nd, 2004 07:24 PM |
COMPARE THE TWO TABLES | Stefanie | General Discussion | 0 | June 4th, 2004 04:36 PM |
what function copies data from an excel form to excel table | Debra Dalgleish | Worksheet Functions | 0 | February 10th, 2004 02:48 AM |
can I hide a series in a stacked bar chart but keep the series in the data table | Stephen Bullen | Charts and Charting | 0 | December 5th, 2003 10:53 AM |