Replicating values in fields based upon other records

[tebbr]

I'm importing a text file for analysis and am looking for a way to value a field in a record based upon the value in the previous row of the report.

The report looks like this

Account Sub Account
1234 ABDF
FHGI
STUV
4239 NUPD
DRVG


I'm looking to populate the 1234 on the records that contain FHGI and STUV and the 4239 with the DRVG, etc.

IS there a quick way to do this while importing the file into access?

 

[tebbr]

I'm importing a text file for analysis and am looking for a way to value a field in a record based upon the value in the previous row of the report.

The report looks like this

Account Sub Account
1234 ABDF
FHGI
STUV
4239 NUPD
DRVG


I'm looking to populate the 1234 on the records that contain FHGI and STUV and the 4239 with the DRVG, etc.

IS there a quick way to do this while importing the file into access?

Looks Like I lost the formatting when submitting the post....Re applied

 

[tebbr]

I keep losing the formatting The report has the Numeric values in the first column and all of the Alpha values in the second column. I would like to have the numeric values repeated for each alpha value. So each row of the table would contain a Numeric followed by an also value

1234 ABDF
1234 FHGI
1234 STUV
4239 NUPD
4239 DRVG

 

[Joe4]

See: https://support.microsoft.com/en-us/kb/210504

Also note that CODE tags will maintain spaces, QUOTE tags will not.
If you use the Advanced Editor, you can Preview your posts before posting them.

 

[HiTechCoach]

You will need to use VBA code to loop through the records and write the data to the desired table.