populating data fields

  • Thread starter Thread starter Bolivar
  • Start date Start date
B

Bolivar

I have thousands of entries and a tracking number is in one field and items
belonging to that tracking number are in another field. The tracking number
itself is not populated down with the numbers relateing to it and each
tracking number has a different number of items associated with it. I need to
populate the tracking number to fill in the blank data fields below it
123 abc
cab
gef
124 ced
rad
 
I use Excel autofill to do it.
Add a new column to left of Tracking number, add a row under, and enter this
formula in A2 -- =IF(B2="", A1, B2)
A B C
1
2 123 abc
3 cab
4 gef
5 124 ced
6 rad
Then drag to fill column A.
 
I use many applications to manipulate my data to get it into Access for
analysis.
Some examples are Excel, Word (text files), and even WordStar as it can do
column work in a text file.
 
Hi, I have the exact same issue as Bolivar, except I have 870,000 lines. I
have been successful with the below example, but I would need to create at
least 15 spreadsheets. Is it possible to do this in Access?
 
Back
Top