Results 1 to 3 of 3
  1. #1
    TIG_Slayer is offline Novice
    Windows 7 64bit Access 2010 64bit
    Join Date
    Jul 2014
    Posts
    11

    Automated Reporting

    Hello, I am currently working on creating an automated report using access. I have a query that creates a crosstab, and then exports it to excel. My problem is that new items will be appended to the report and will cause some issues when it comes to graphing them. How can I go about appending new items, but having the previous cells stay with the same graph they were referenced to before? Sorry if this sounds very confusing, but I am trying to explain the best I can.

    Here's a simple example:
    Apple
    Banana
    Orange



    If you were to append grape, it would now be:
    Apple
    Banana
    Grape
    Orange

    So now the cells that were used before to graph the sales of Orange would be incorrect, and would be graphing grape instead.

    As said earlier, any help is appreciated, and sorry if it sounds confusing.

  2. #2
    ranman256's Avatar
    ranman256 is offline VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    8,624
    Orange you glad I didnt say banana?

    Ok, yes the data exports to the same page even w data in it.
    So you must either:
    delete the existing xl file, and use a template that has the graphs in it for the new sheet.
    or
    take control of xl, clear the data in the sheet, THEN export the data.

  3. #3
    TIG_Slayer is offline Novice
    Windows 7 64bit Access 2010 64bit
    Join Date
    Jul 2014
    Posts
    11
    Quote Originally Posted by ranman256 View Post
    Orange you glad I didnt say banana?

    Ok, yes the data exports to the same page even w data in it.
    So you must either:
    delete the existing xl file, and use a template that has the graphs in it for the new sheet.
    or
    take control of xl, clear the data in the sheet, THEN export the data.

    Very punny haha.
    That helps a little bit, but I am no pro when it comes to excel or access. Essentially I want to export the crosstab using a macro to excel, and then from that exported excel file, link the values in that crosstab to another excel workbook that has seperate sheets and graphs for the items. The complication is when the new items are appended after all is said and done, it will cause the cells to be referenced incorrectly. I know i could probably do this without it being in ascending order and it wouldn't be an issue, but I would like the crosstab to be in ascending order. Hopefully this makes sense.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Can this be automated on access
    By montypython in forum Database Design
    Replies: 1
    Last Post: 05-23-2012, 10:22 AM
  2. Automated E-mail
    By imintrouble in forum Access
    Replies: 4
    Last Post: 01-11-2012, 10:28 AM
  3. Automated import
    By salisbut in forum Import/Export Data
    Replies: 2
    Last Post: 07-16-2010, 12:56 PM
  4. automated macros?
    By tom4038 in forum Programming
    Replies: 1
    Last Post: 09-24-2009, 02:57 AM
  5. Automated many Rpts from one??
    By techexpressinc in forum Reports
    Replies: 0
    Last Post: 07-21-2009, 08:20 AM

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums - Senior Forums