Solved

Changing "Question" Header order

Posted on 2013-02-04
19
217 Views
Last Modified: 2013-02-24
I have a database report which is part of a survey.  In this report I have as a header QUESTION.  This is the question that the patient was asked to answer.  

I would like to put these questions in a certain order.  Not by Ascending or Descending but my own order.  Can this be done?

I am attaching a copy of the Design view of the report.



K
question-order.JPG
0
Comment
Question by:kvrogers
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 10
  • 9
19 Comments
 
LVL 29

Expert Comment

by:IrogSinta
ID: 38853129
Sure, add a field in your question table where you can enter your sort order.  Then use that field (instead of the Question field) as the header of your report and this header section is where your question goes.
0
 

Author Comment

by:kvrogers
ID: 38855481
I am kind of a newbie to this and I don't understand.  So if I create this field, how do I indicate the order in which I wish the questions to appear.  There are 20 questions.    Attached is a database from last year.  All pt information has been stripped.

She wants these grouped in a certain order so I'm wondering if that means I should create subreports to get them grouped together correctly.

Any help is GREATLY appreciated.

K
Vakassi-and-Hayat-Database2.accdb
0
 
LVL 29

Expert Comment

by:IrogSinta
ID: 38857749
So you don't really have a table of questions here.  Can I ask how you get the data into your table?
0
[Live Webinar] The Cloud Skills Gap

As Cloud technologies come of age, business leaders grapple with the impact it has on their team's skills and the gap associated with the use of a cloud platform.

Join experts from 451 Research and Concerto Cloud Services on July 27th where we will examine fact and fiction.

 

Author Comment

by:kvrogers
ID: 38858910
Import data from survey website into excel.
K
0
 

Author Comment

by:kvrogers
ID: 38858915
I did download data again and in the field I labeled Question, I numbered them 1-26 in the order my boss wanted them and that worked.
K
0
 
LVL 29

Expert Comment

by:IrogSinta
ID: 38859141
I'm not sure I follow. Did you have to number each question multiple times for each response? Will you have to do this every time you download the survey?
0
 

Author Comment

by:kvrogers
ID: 38861222
Each question was given a number after I downloaded into Excel.   I filtered through each question such as "Please indicate the provider of your appointment".  She wanted this to be #1 question, so I filtered to this question and changed the question to "01 Please indicate the provider of your appointment" for each response.   I didn't know how to create a column with the numbers.

Problem #2.  Now she wants the reponses to be VERY POOR to VERY GOOD not in alpha or reverse alpha order.  The other answers like DOES NOT APPLY to be the last answer.  So, Yes,No, Does not apply. In that order.

Thanks,
K
0
 
LVL 29

Expert Comment

by:IrogSinta
ID: 38861929
So will you import a new survey every now and then or is it a one time download?
0
 

Author Comment

by:kvrogers
ID: 38864337
Every six months there will be new surveys.  I currently have three to download but I want to get this one correct before I move on.  

Here is the most recent survey in Excel format.  I stripped away all patient contact information.  Hope this is helpful.  

K
January-Family-Practice-Survey-2.xlsx
0
 
LVL 29

Expert Comment

by:IrogSinta
ID: 38866855
I didn't make use of the Excel file you uploaded.  I just revised your database a bit by adding tables for sorting.  To change your sort order,  just change numbering in the SortNumQ field in the tbl_Questions.
Vakassi-and-Hayat-Database2.accdb
0
 

Author Comment

by:kvrogers
ID: 38872394
How do I create a cross tab query for new survey with all family practice doctor of 12 to use in report?
0
 
LVL 29

Expert Comment

by:IrogSinta
ID: 38872396
I don't understand what you mean about 12. Can you explain a bit more?
0
 
LVL 29

Accepted Solution

by:
IrogSinta earned 500 total points
ID: 38873453
This revision should allow you to have more than 2 providers.  You would need to manually update your report to add the additional providers (labels and textboxes).  You probably should make it landscape so that they would fit.
Vakassi-and-Hayat-Database2-revi.accdb
0
 

Author Comment

by:kvrogers
ID: 38902744
Before I could use a SurveyResults_query.  (see attached)  Then when I did my crosstab query it would show all the doctors name.  (see attached).

I noticed that you put in some type of query builder how did you do that?

Your report above is perfect! But I can't get the new report to look like it.  


K
Survey-Results.JPG
Crosstab-Query-results.JPG
0
 

Author Comment

by:kvrogers
ID: 38903542
Ok the only thing that is not correct is that the Questions are not coming in the correct order.  I sort by SORTNUMQ and the attached is how I have it set up but can't get the TOTAL BY to say NONE.

K
Group-on-SortNumQ.JPG
0
 
LVL 29

Expert Comment

by:IrogSinta
ID: 38912318
I don't follow what you're trying to do with Total By.  Why not upload the database as you have it now and I'll take a look at it.
0
 

Author Closing Comment

by:kvrogers
ID: 38920028
I just wanted the user IrogSinta to explain how he created the Query Builder and the steps he took to create the code and what the code means.  Copy and pasting seems like cheating if I don't know how and why it was done.

K
0
 
LVL 29

Expert Comment

by:IrogSinta
ID: 38920535
I was under the impression that the code and queries I gave helped you in understanding what you were trying to do.  If you are not sure what the new code is doing, just ask, but please be specific with your question since there are a number of things going on in your database, and it would be difficult to explain everything at once.

Ron G.
0
 

Author Comment

by:kvrogers
ID: 38923234
Thanks.
K
0

Featured Post

Enroll in July's Course of the Month

July's Course of the Month is now available! Enroll to learn HTML5 and prepare for certification. It's free for Premium Members, Team Accounts, and Qualified Experts.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

It’s the first day of March, the weather is starting to warm up and the excitement of the upcoming St. Patrick’s Day holiday can be felt throughout the world.
This article describes two methods for creating a combo box that can be used to add new items to the row source -- one for simple lookup tables, and one for a more complex row source where the new item needs data for several fields.
Learn how to number pages in an Access report over each group. Activate two pass printing by referencing the pages property: Add code to the Page Footers OnFormat event to capture the pages as there occur for each group. Use the pages property to …
In Microsoft Access, learn how to “cascade” or have the displayed data of one combo control depend upon what’s entered in another. Base the dependent combo on a query for its row source: Add a reference to the first combo on the form as criteria i…

624 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question