Results 1 to 5 of 5
  1. #1
    New Lounger
    Join Date
    Aug 2005
    Posts
    16
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Query/Report shortcut anyone?? (Access)

    I am reviewing a huge spreadsheet (350,000 rows) on access, and have been assigned to create a new report based on the name of each agent listed (there are 2800 agents to analyze and each agent has approximately 25 columns of data). For now, we have been cutting/pasting data based on agent name into new worksheets in excel --(the current project is extremely time consuming!!)

    Is there an easier way to break down this data using a shortcut of any nature--or is there a query/report we can run that will seperate this data easier by any chance? I'm happy to make some clairifications on this, as I know this request may seem vague...
    Thanks much,

    Lori

  2. #2
    New Lounger
    Join Date
    Aug 2005
    Posts
    16
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Page breaks in Access

    I am continuing the brainstorm on how to find a solution to my large access project...the main objective to this project is to create seperate 'reports' for each agent...would inserting page breaks upon change in agent identification numbers help get to this goal? If so, how do I incorporate them, while keeping the field names at the top??

    Thanks again...

  3. #3
    5 Star Lounger
    Join Date
    Nov 2004
    Location
    Wilmington, North Carolina, USA
    Posts
    1,196
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Page breaks in Access

    Lori,

    Try to keep your ideas in one post (I'm assuming this relates to your post about keeping the headers together). I'll respond to your questions in that thread.
    ____________________________
    Jeremy
    "If you spend more on coffee than on IT security, then you will be hacked. What's more, you deserve to be hacked." -Richard Clarke

  4. #4
    Lounger
    Join Date
    Feb 2005
    Location
    Albuquerque, New Mexico, USA
    Posts
    45
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Query/Report shortcut anyone?? (Access)

    So you have a large amount a data in an Access table right? You can create a query of the data you wish to include on the reports even if it contains all of the data columns you talk about. Once you create and save a query, you can use the report wizard in Access to create a report that will seperate the data into sections of a report that will allow you to put in a page break after each agent report. Access is pretty good at walking you through this so try it. If if doesn't come out in the format you want the first time, delete the report and run through the wizard again. Hope that helps. If you need more information on a particular step, just post back in here again and someone will help you if I can't.

  5. #5
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Query/Report shortcut anyone?? (Access)

    No point in having two threads about the same subject. Please post all further replies in the thread starting at <post:=541,943>post 541,943</post:>. This one is locked to avoid confusion and duplication.

Posting Permissions

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