Results 1 to 8 of 8

MS Access to Excel Output

  1. #1
    rjbautista20 is offline Novice
    Windows XP Access 2010 32bit
    Join Date
    Jan 2012
    Posts
    23

    MS Access to Excel Output

    Good day to all,

    I am novice in programming in getting result in ms access to excel

    what i would like to do is:

    1. Count the number of the document base on Country
    2. Sum the value base on country
    3. Divide the Total Count to Total Sum base on country


    Hope you guys can help.

    Thanks so much

  2. #2
    June7's Avatar
    June7 is online now Moderator
    Windows XP Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    29,447
    What you describe is aggregate (summary) calculations. They can be accomplished in a GROUP BY query or in an Access report. Programming likely not needed. Access Help has guidelines on building queries and reports.

    Why do you need to export to Excel?
    To provide db: Make copy, remove confidential data, run compact & repair, zip if large - 2mb allowed, attach to post. Attachment Manager is below the Advanced post editor window.
    If suggestion in this post resolves your issue, please use the Thread Tools and mark the thread as Solved!

    Debug!Debug!Debug! http://www.cpearson.com/excel/debug.htm

  3. #3
    rjbautista20 is offline Novice
    Windows XP Access 2010 32bit
    Join Date
    Jan 2012
    Posts
    23
    @june7, thanks for your reply.

    actually, i'd done that already. i know on how to query in ms access.

    excel will be the output.

    For e.g.

    I have two columns of No of Inv and Post Number

    in US: I want to count the No of Inv and divide it Total Number of Post Number

    i hope you understand my explanation.

    Thanks.

  4. #4
    June7's Avatar
    June7 is online now Moderator
    Windows XP Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    29,447
    You know how to do the GROUP BY query? Then what is the specific issue you are having?

    Can export to Excel and do whatever calcs you want.
    To provide db: Make copy, remove confidential data, run compact & repair, zip if large - 2mb allowed, attach to post. Attachment Manager is below the Advanced post editor window.
    If suggestion in this post resolves your issue, please use the Thread Tools and mark the thread as Solved!

    Debug!Debug!Debug! http://www.cpearson.com/excel/debug.htm

  5. #5
    rjbautista20 is offline Novice
    Windows XP Access 2010 32bit
    Join Date
    Jan 2012
    Posts
    23
    yes i know how to do GROUP BY in query. after grouping, I want to get data directly from ms access to excel on a per result field

    Thanks again for your reply

  6. #6
    June7's Avatar
    June7 is online now Moderator
    Windows XP Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    29,447
    Still not sure what you need. Do you need to know how to export?
    To provide db: Make copy, remove confidential data, run compact & repair, zip if large - 2mb allowed, attach to post. Attachment Manager is below the Advanced post editor window.
    If suggestion in this post resolves your issue, please use the Thread Tools and mark the thread as Solved!

    Debug!Debug!Debug! http://www.cpearson.com/excel/debug.htm

  7. #7
    rjbautista20 is offline Novice
    Windows XP Access 2010 32bit
    Join Date
    Jan 2012
    Posts
    23
    hi again,

    yes i know how to export a query. i'd like instead getting data from ms access without exporting.

    Thanks.

  8. #8
    June7's Avatar
    June7 is online now Moderator
    Windows XP Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    29,447
    Copy/paste records is the only other way I know to get data from Access to Excel.

    If your problem is how to divide the aggregate sums, do another query that uses the aggregate query as source.
    To provide db: Make copy, remove confidential data, run compact & repair, zip if large - 2mb allowed, attach to post. Attachment Manager is below the Advanced post editor window.
    If suggestion in this post resolves your issue, please use the Thread Tools and mark the thread as Solved!

    Debug!Debug!Debug! http://www.cpearson.com/excel/debug.htm

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

Similar Threads

  1. Replies: 4
    Last Post: 01-05-2012, 06:31 PM
  2. Output Report to Excel
    By BLD21 in forum Reports
    Replies: 5
    Last Post: 04-26-2011, 06:53 AM
  3. Output tables to an excel file on a network drive
    By GraemeG in forum Import/Export Data
    Replies: 1
    Last Post: 04-01-2011, 02:06 PM
  4. Formatted Excel Output
    By jerryrs in forum Import/Export Data
    Replies: 6
    Last Post: 02-26-2011, 09:58 PM
  5. URGENT HELP: output to excel
    By jerryrs in forum Import/Export Data
    Replies: 1
    Last Post: 12-22-2010, 10:18 AM

Posting Permissions

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