Updating Records in a Query

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I download a report to a text file, unfortunately, the file is in a "report"
format. The report list line items in groups. There is a header for each
group which identifies the user responsible for the following records in the
group. I created a field in the table called REP. But it is only populated
ONCE per group of records. The rest is NULL. Is there a way to query the
table and retrieve JUST the records within each group following the display
of REP and update the NULL fields with the REP for the records within the
group. The query should stop when it comes to a different REP.

Thanks
 
I always use Excel autofill to do this for me. Inser new column and place
first group name in A1.
IF(B2="",A1,B2)
Test if REP is empty and copies from cell above or from the new group name.
 
Back
Top