Can't normalize data and trying to do workarounds.

[The_Vincester]

This has been a nightmare all around. Because I can't get 40 licenses for Access I'm stuck doing transferspreadsheets every day, which has worked out mostly, but I'm reaching the absolute limits of my knowledge. I can't even think straight and need help with a solution.

Here is the table data I'm bringing in (in a simple way)

Editor        Client      ResearchHits    HitsSent     AltEditor    Pruned    Edited
J. Doe     Coca Cola      1000             500           
J. Doe     Coca Cola                                     J. Schmoe    200      100

This data is brought in from two imports of data (there is actually a date column too that I didn't include). Now, what I need to do is have it subtract the "Pruned" from the "ResearchHis" and the "Edited" from the "HitsSent" while only showing Coca Cola and J. Doe once... is this possible?

Thanks.

 

[grnzbra]

How about an agregate query that sums each column grouped on editor and client and then use that to drive a query that does the subtraction?

 

[The_Vincester]

Yep, I just figured it out and that's pretty much how I did things.

Thanks for the help...