Results 1 to 2 of 2
  1. #1
    Kennyej is offline Novice
    Windows 7 64bit Access 2013
    Join Date
    Jul 2015
    Posts
    4

    Excel or reports?

    My predecessor used excel very inefficiently. I know that access is better suited for the job as far as entering data. He has tables in excel formatted into a company weekly report format. My question is:



    Would it be easy enough to recreate this weekly report format in an access report? Or should I just do queries and import the data to excel? I'm new at access but am figuring it out at a decent pace. Thoughts? I'm not that familiar with reports yet.

  2. #2
    pbaldy's Avatar
    pbaldy is offline Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    22,652
    I do most reporting in Access. I typically only export to Excel when the user wants to be able to manipulate the data themselves. I don't do much charting, but I have heard that charting is more powerful in Excel, so some export Access data to Excel for that.
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

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

Similar Threads

  1. Excel Reports
    By Bschmale in forum Access
    Replies: 2
    Last Post: 03-02-2015, 12:30 PM
  2. Replies: 3
    Last Post: 01-25-2014, 03:40 PM
  3. Replies: 1
    Last Post: 01-22-2013, 02:01 PM
  4. Replies: 0
    Last Post: 03-13-2011, 03:09 PM
  5. Replies: 2
    Last Post: 01-24-2010, 09:19 PM

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