Hello!

I am working with Access 2007 and I have a database created. I have survey results that I need to enter into my db. I have set up a form with all applicable fields and set the form as continuous, assuming this is correct. Since I will have several batches of survey results on various days, I want to enter one date and all surveys from that day. Essentially, I need 4 of the fields to remain the same (Date, Course, Instructor, Quantity in batch, Quantity in class and Facilitator) until I click "New" to enter a new batch.

How can I proceed?

Thanks!

Am I missing something? There are 6 fields in your list, not 4:



Which 4 are staying the same? What does your table structure look like for these surveys? It seems you just need to break out the 4 fields into a separate table, and link them to the survey results table. Then you can just insert the continuous form as a subform and your 4 fields will be in the main form.

You are right, there are 6. Initally there were four but as I typed in the field names, I realized a couple more could be added. I just forgot to recalculate! Sorry. All six will need to stay the same. My table consists of the six fields mentioned before along with the typical survey questions, i.e. this course was beneficial to me; the instructor was informative, etc. They are given 5 options, 5-Highly Agree; 4-somewhat agree, so on and so forth.

So, I need to set up a table for each of the six fields and link back to my main table? Correct?

Hello!

Question. I have an access database (2007) that I use to enter survey results from our course. The table setup is as follows:

Course
Date
Facilitator
Support, etc.


1) Was this event helpful (5 - Strongly Agree; 4 - Agree; 3 - Good; 2 - Fair; 1- Poor)

2) Were the facilitators helpful(5 - Strongly Agree; 4 - Agree; 3 - Good; 2 - Fair; 1- Poor)

I want to create a chart that displays the total "Strongly Agrees", "Agrees", "Goods", etc in a pie chart. The table has all questions as column headings and each row is an individual survey. When I try and display a pie chart (Ideal), it is creating the chart with each individual record instead of all records for 5 - Strongly Agree; 4 - Agree; 3 - Good; 2 - Fair; 1- Poor



Any ideas?

Hello!

Question. I have an access database (2007) that I use to enter survey results from our course. The table setup is as follows:

Course
Date
Facilitator
Support, etc.


1) Was this event helpful (5 - Strongly Agree; 4 - Agree; 3 - Good; 2 - Fair; 1- Poor)

2) Were the facilitators helpful(5 - Strongly Agree; 4 - Agree; 3 - Good; 2 - Fair; 1- Poor)

I want to create a chart that displays the total "Strongly Agrees", "Agrees", "Goods", etc in a pie chart. The table has all questions as column headings and each row is an individual survey. When I try and display a pie chart (Ideal), it is creating the chart with each individual record instead of all records for 5 - Strongly Agree; 4 - Agree; 3 - Good; 2 - Fair; 1- Poor



Any ideas?

Can you list the table(s) you have so far and their fields? I believe there are some sample databases on this site that deal with how to setup surveys - I will try to have a look as well when I have some more time.

Typically you wouldn't setup each question as a column, as that would mean having to add a new column every time you want a new question, which means modifying tables and queries. If each question were a record with an associated value of 5 (Strongly Agree), 4 (Agree), 3, etc. then you could just do a count of how many 5's, 4's, etc. there are for your totals Pie chart.

Hi

The attached is an example of a Survey taken from the Archives

Click to view attachment

You can use the AfterUpdate event of the Control holding your data to set the DefaultValue for the Field. From that time forward, until you either manually change the data or close your Form, the data will be entered automatically in each New Record.

So, for each of the Fields to be 'carried forward,'

This same code/syntax can be used for any Datatype.

You can either simply enter the new data into these Controls, overwriting the Default Values, when starting to enter a new batch, or use your New Batch command button to Reset the Default Values to nothing, and then enter the new data, which will then be carried over until changed.

Linq ;0)>