Database col fill

Resolved · Medium Priority · Version 2003

Mon 9 Jan 2012, 11:50 Edited on Mon 9 Jan 2012, 12:04 Delegate Barry said...

Barry has attended:
No courses

Database col fill

Hi all, I have a database (over 18,000 rows) which shows the same name against different codes but they have the same postal address. What I am trying to do is put the same name against these codes with the same address other than copy & pasting the name against the codes with 18,000 it will take months to do. An example is below.

Code Names
XX12 SMITH
YY45
LL66
LL66
AA78 COURT
FF33
FF33
FF33
FF33
FF33
TT90 JAMES
TT90
HH14 HEART
HH14
HH14
RG49

Where the blanks are is where the names have to be filled in. For example SMITH also needs to be filled into the 3 rows below the name, COURT to go in the 5 rows below etc etc. Does anyone have any idea of the best way to fill in the blanks with the names? It can be in Access or Excel 2003.

Many thanks for any guidance.

Baz

Mon 9 Jan 2012, 15:40 Trainer Anthony said...

RE: Database col fill

Hi Barry, thanks for your query. Take the data into Excel and split it so Column A has the codes and column B has the names.

Copy column B, so it has the same names in the same positions.

In C2 put the following formula:

=IF(B2="", C1, B2)

Hit enter then autofill down from C2

Voila!

Hope this helps,

Anthony

Mon 9 Jan 2012, 16:09 Delegate Barry said...

RE: Database col fill

Hi Anthony, I take it the copied col B goes in to col "C"? Done that anyway & put your formula in C2. Copied down the formula over 18,000 rows & it worked a treat. I can now sort out the rest of the Excel s/sheet then import it into Access where I can continue working on it.

Great.

Thanks a lot Anthony. 5 stars for you m8.

Baz

Training courses

	98.8 % recommend us
	More live stats...

Training information:

Access tip:

Using the Quick Access Toolbar in Access 2010

The Quick Access Toolbar is included in virtually every Office product, including Outlook 2010, Word 2010, Excel 2010, and PowerPoint 2010.

You will find the Quick Access Toolbar in the top-left side of the window. To begin, click the Customize button (it's the little black arrow at the end of the toolbar).

Simply click the commands you want to include.

Virtually any command can be added to the Quick Access Toolbar. Click the More Commands option and a new window will open from where you can browse the commands including those not on the ribbon.

View all Access hints and tips