If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Group by Field in a Report
I'd like to create a report that displays responses from several survey
participants. Ideally the report would look like this: Q1 1st Survey Respondent's Name 1st Survey Respondent's Response to Q1 2nd Survey Respondent's Name 2nd Survey Respondents Response to Q1 3rd Survey Respondent's Name 3rd Survey Respondent's Response to Q1 |
#2
|
|||
|
|||
Group by Field in a Report
This would be quite simple if your tables were normalized like the At Your
Survey demo found at http://www.rogersaccesslibrary.com/O...p#Hookom,Duane. You can normalize your structure with a union query SELECT RespName, 1 as Question, [Q1] as Response FROM tblNoNameGiven UNION ALL SELECT RespName, 2, [Q2] FROM tblNoNameGiven UNION ALL SELECT RespName, 3, [Q3] FROM tblNoNameGiven UNION ALL SELECT RespName, 4, [Q4] FROM tblNoNameGiven UNION ALL --- etc --- FROM tblNoNameGiven; You can then create a query based on the union query. -- Duane Hookom MS Access MVP -- "Chad Borman" wrote in message ... I'd like to create a report that displays responses from several survey participants. Ideally the report would look like this: Q1 1st Survey Respondent's Name 1st Survey Respondent's Response to Q1 2nd Survey Respondent's Name 2nd Survey Respondents Response to Q1 3rd Survey Respondent's Name 3rd Survey Respondent's Response to Q1 . . . . . . nth Survey Respondent's Name nth Survey Respondent's Response to Q1 Q2 1st Survey Respondent's Name 1st Survey Respondent's Response to Q2 2nd Survey Respondent's Name 2nd Survey Respondents Response to Q2 3rd Survey Respondent's Name 3rd Survey Respondent's Response to Q2 . . . . . . nth Survey Respondent's Name nth Survey Respondent's Response to Q2 and so on. I have a field for each response (i.e., all reponses to Q1 are in one field, all responses to Q2 are in another field) and a field for the survey respondent's name). I can't find anything in the documentation that addresses this. I would think some sort of 'grouping' would work, but I haven't been able to figure it out. Any help? Thanks. |
#3
|
|||
|
|||
Group by Field in a Report
Thanks a lot, Duane. It works (I have to brush off my limited SQL knowledge
and start using it again). "Duane Hookom" wrote: This would be quite simple if your tables were normalized like the At Your Survey demo found at http://www.rogersaccesslibrary.com/O...p#Hookom,Duane. You can normalize your structure with a union query SELECT RespName, 1 as Question, [Q1] as Response FROM tblNoNameGiven UNION ALL SELECT RespName, 2, [Q2] FROM tblNoNameGiven UNION ALL SELECT RespName, 3, [Q3] FROM tblNoNameGiven UNION ALL SELECT RespName, 4, [Q4] FROM tblNoNameGiven UNION ALL --- etc --- FROM tblNoNameGiven; You can then create a query based on the union query. -- Duane Hookom MS Access MVP -- "Chad Borman" wrote in message ... I'd like to create a report that displays responses from several survey participants. Ideally the report would look like this: Q1 1st Survey Respondent's Name 1st Survey Respondent's Response to Q1 2nd Survey Respondent's Name 2nd Survey Respondents Response to Q1 3rd Survey Respondent's Name 3rd Survey Respondent's Response to Q1 . . . . . . nth Survey Respondent's Name nth Survey Respondent's Response to Q1 Q2 1st Survey Respondent's Name 1st Survey Respondent's Response to Q2 2nd Survey Respondent's Name 2nd Survey Respondents Response to Q2 3rd Survey Respondent's Name 3rd Survey Respondent's Response to Q2 . . . . . . nth Survey Respondent's Name nth Survey Respondent's Response to Q2 and so on. I have a field for each response (i.e., all reponses to Q1 are in one field, all responses to Q2 are in another field) and a field for the survey respondent's name). I can't find anything in the documentation that addresses this. I would think some sort of 'grouping' would work, but I haven't been able to figure it out. Any help? Thanks. |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Parameter thru Form Dialog Box for REPORT | Sandy | Setting Up & Running Reports | 16 | January 10th, 2006 10:06 AM |
Reporting subreport total on main report | BobV | Setting Up & Running Reports | 22 | November 1st, 2005 03:19 AM |
No current record 3021 | hughess7 | General Discussion | 30 | August 19th, 2005 04:39 PM |
Ambiguous outer joins | Renwick | New Users | 1 | February 22nd, 2005 02:08 PM |
Still Hoping for help with a Query problem | Don Sealer | Using Forms | 15 | November 13th, 2004 06:24 AM |