Combining Records

[Guest]

I have data that shows similar records that I got from querying a database.

Date WO # Press # Operation Op Time
12/01/04 XXXXX1 143 012 1.58
12/01/04 XXXXX1 143 012 0.96
12/01/04 XXXXX1 143 012 4.28
12/01/04 XXXXX1 143 012 1.02
12/01/04 XXXXX2 105 011 0.67
12/01/04 XXXXX2 105 011 3.30
12/01/04 XXXXX2 105 011 1.28

I would like a macro or code that recognizes the similar rows, combines them
into one, and sums the Op Time.

 

[George Nicholson]

Is this an Access question or an Excel question?

If an Access question, look up query in Help, specifically a Totals Query.

HTH,

 

[Guest]

It's an Access question.

Is this an Access question or an Excel question?

If an Access question, look up query in Help, specifically a Totals Query.

HTH,

 

[Guest]

Use a Totals Query . . . Sum the Op Time field

It's an Access question.