How can I compare rows in access and move info from one row to ano

P

PC CHIC 1

I just cannot figure this out. Here is an example of my data sheet:

CHANGE ID REQUESTER NAME & ID GROSS BUSINESS MET SLO?
1828340 STUMPF, LISA (CNC-NH733) 2,689.4 877.4
RUSSELLL RECORD_STATUS 188.4

The CHANGE ID row is the header row. The next two are individual records.
Basically the spreadsheet is set up with a Ticket number and then in the
following rows if the ticket was on hold, it lists the hold times. I need to
be able to subtract the hold times (in this case 188.4) from the net open
time (in this case 877.4) and then store it in the field to the right of the
877.4.

I do this in Excel easily. But need to automate more of my data work. Any
advice would be appreciated.
 
S

Seth Schwarm

PC Chic:

I think there is a way to help, but I can't quite make heads or tails of
your example. It seems like maybe two ideas collided within the example in
the post.

If you can clarify, I think an answer can be developed.

Seth Schwarm
 
Top