RE: copy a value from one record into other records.

Assuming you add a sequence field named ID, you could create an update query
like:

UPDATE tblNoName SET tblNoName.C1 =
DMax("tblNoName.[C1]","tblNoName","[ID]<=" & [ID]);

--
Duane Hookom
Microsoft Access MVP


"AlKolwicz" wrote:

Yes, I can add a primary key. the records are sequential.

Al

"Duane Hookom" wrote:

Nearly impossible or at least un-reliable without a field that describes the
exact sequence of the records. You have a couple records with only A in C2.
Access tables doesn't necessarily know the difference between the two
records. The same is true for the two records with B.

Do you have a primary key in the table that you aren't telling us about? If
you don't have one, can you create one?

--
Duane Hookom
Microsoft Access MVP


"AlKolwicz" wrote:

I have the following rows and columns in a table
C1 C2
1
A
B
2
A
B
C
etc.

I want to duplicate the value in column 1 into the following records.

1
1 A
1 B
2
2 A
2 B
2 C
etc.

I can do this in Excel. Is there a way to do it in Access?

-Al
.

Relevant Pages