Fill Blanks

[M Saqib]

Hi,

I have two column A & B.

A B
Saqib 1
2
3
4
Nazim 1
2
3
4
I want A column be filled by query in Access like mentioned below.

A B
Saqib 1
Saqib 2
Saqib 3
Saqib 4
Nazim 1
Nazim 2
Nazim 3
Nazim 4

Hoping to get the answer of aforesaid query from you expert guys.

 

[Gina Whipp]

M Saqib,

You cannot do this by query alone. Have a look at...
http://www.regina-whipp.com/index_files/CopyFields.htm

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

 

[Duane Hookom]

You could probably do this with SQL if you had another field that was a
primary key and identified the order as displayed.