Results 1 to 3 of 3
  1. #1
    Join Date
    Jun 2004
    Posts
    39

    Unanswered: replace subtotals

    hi,
    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.
    Thanks.

  2. #2
    Join Date
    Jun 2004
    Location
    Terrapin Nation
    Posts
    205
    Create a function in Excel to go to your Access tables and change the values as appropriate.

  3. #3
    Join Date
    Jun 2004
    Posts
    39
    could u help me out, as to what would be the function and how to write it.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •