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!!