i need to do something like this.
using access code i'm dumping a query result to excel and there i do some calculations,formatting and i even do subtotals on 2 different fields.
subtotals are done on customer and productgroup fields.
now i need to change display name of one product group, ie "COS Total" to the previous Subtotal display name "ASP Total" or "COD Total".
I need to do this for every occurence of the total, using access.
Can anyone help me.