Repeat of row parameter

[csrathore]

My data are like this:

catalog no. Deptcode Respcode Projections
02397360101 34 346103 12
------do---------- 33 336001 1
------do---------- 36 366001 4
------do---------- 31 316001 7

02173212532 35 356103 8
------do---------- 34 346001 8
------do---------- 36 366001 5
------do---------- 32 326001 6

It should be arranged like this:

Cat no. Dept code Resp code projections

02397360101 34 346103 12
02397360101 33 336001 1
02397360101 36 366001 4
02397360101 31 316001 7

02173212532 35 356103 8
02173212532 34 346001 8

……And so on

How to repeat the cat no. in all rows till the begining of data of next cat no.? please suggest.

[Stewart Ross]

If the field values marked '------do----------' are real values of some kind (not just some sort of shorthand you used for the purposes of posting example data) then your data is completely unnormalised and not suitable for processing via a relational database. It looks like something that may have come from a manually-entered spreadsheet, with all the attendant problems that manual data entry will bring.

Although it is possible to process the data record by record using recordset processing to replace the '------do----------' values with the last known catalogue number, I could not as it stands recommend any form of processing being applied to the data as you have shown it (if I am interpreting your question correctly).

I would instead advise you to go back to the source of the data and see whether you can get hold of it without the data loss represented by the substitution of '------do----------' for the catalogue number.

-Stewart

[csrathore]

Dear Stewart,

field below the cat no. are empty field i use --do-- for posting example data as you have rightly mentioned it. actually these data base is of projections given by different users department with different responsibility code. so, for a cat no. many users department can give their projections.
I hope this will clarify further i you will be able to solve the problem.
-csrathore

[NeoPa]

Bearing in mind that data stored in any RDBMS is not held in the order it was entered unless specifically programmed to do so, how do you think it's possible, from the information you've given, to determine which value of [Catalog No] to use for any specific record? By completely leaving out any explanation of how you want the logic to determine this, you have implied that you want it done in that way which is not possible.

So, unless you include the whole question in your question, we are in no position to suggest any solution.