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

[Guest]

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.

 

[Guest]

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

 

[Joseph Meehan]

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.

I can't figure out what you want, but a couple of bells do go off.

"Ticket number and then in the following rows if the ticket was "

In a row (record) in a database, one row does not refer to a prior or
past row (record). Each record is independent and unless you provide for it
has no specific order in relation to other records or rows. They tend to
display in order but that can unexpectedly. It appears you are trying to
use the database as a spreadsheet. In a database this type of relationship
often is recorded in parent - child related tables.

" 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."

This is also a spreadsheet sin. In a database you normally would not
save the results of a calculation, but rather recalculate it whenever it is
needed. The only exception to this rule would be when one of the factors in
the calculation may change and you want to retain the original answer for
some reason. For example you would store the amount someone paid for three
items at $1.00 each because next week those same items might cost $1.20
each. But if you were valuing the stock on hand you would not want to store
the result because the value of that stock would change with the price.