Results 1 to 2 of 2
  1. #1
    engineer225 is offline Novice
    Windows 7 64bit Access 2013
    Join Date
    Feb 2014
    Posts
    1

    Thoughts on Query Design for Table Taken off of Web

    Hi Everyone:

    New to the forum. I have an issue where I have a very large table on the web that I need to create a query for to evaluate the data. I have designed the table on paper but since I'm new at Access I am struggling to figure out how to design the query with the raw data to get the output I want. Below is a representative look on how the raw data are when I copy one record from the web and paste into a spreadsheet:



    Last Name, First Name - Organization Name
    Title Begin Date Score End Date
    Manager 1/1/2014 16 2/1/2014

    There are dozens of records that I want to be able to analyze. In my query, the important pieces of data are:

    1. Organization Name
    2. Score
    3. End date (I'm specifically interested in seeing the end date in terms of month, the day is not important)

    In my design, I would like the output to look something like this, where the numbers represent the "score":

    Organization Mar-14 Apr-14 May-14 etc.
    Company 1 26 4 0
    Company 2 20 8 4
    Company 3 20 6 0
    Company 4 0 2 0
    etc.


    Does anyone have any thoughts as to where I can begin in terms of setting up the raw data? There are hundreds of individual records similar to the example I gave and it would take multiple days to go through manually.

    Thank you!!

  2. #2
    June7's Avatar
    June7 is online now VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    53,632
    That looks like a CROSSTAB query. There is a query wizard to help.

    Not seeing fields for Last Name, First Name, Organization.
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

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

Similar Threads

  1. Table Design -- want to avoid a design that creates blank fields
    By snowboarder234 in forum Database Design
    Replies: 4
    Last Post: 10-08-2012, 10:13 AM
  2. Table design or query or?
    By Laaacux in forum Database Design
    Replies: 5
    Last Post: 02-22-2011, 02:13 PM
  3. Thoughts on Dynamic Reporting
    By swalsh84 in forum Reports
    Replies: 2
    Last Post: 09-24-2010, 12:27 PM
  4. Table Design for Query Function
    By Desstro in forum Database Design
    Replies: 1
    Last Post: 09-13-2010, 04:38 AM
  5. My Access Upsizing Nightmare...Opinions and Thoughts?
    By Jerimiah33 in forum Import/Export Data
    Replies: 0
    Last Post: 01-30-2007, 12:40 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