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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Difficult Query; Trying to Show only One Record for only Two Field 1
The query cannot be completed. 1
Code Check Request - Query to find reused values 2
Combining record data 0
How do I split one large table into multiple tables based on field value? 6
Queries & calculations 4
Append query with "if" on possible missing field. 3
Insert Data in One Table from Another Table 2

Back
Top