Hey Everyone,
I am a bit of a noob at this, but have to build this database and
would love some help if anyone can provide any. I have a database
designed at capturing customer satisfaction surveys. I have a table
that captures answers to several different questions, ie;
Q1 - Rating (either Excellent, Good, Average, Poor)
Q1 - Score (either 10, 6.7, 3.3, 0)
The score corresponds with the text rating, these are then compiled to
give an average result for each question, for each staff member over a period of time.
The problem I am having is getting the "Score" to update automatically
depending on the result given in the "Rating" answer.
My table structure is basically like this:
SurveyResults:
SurveyID
CustomerName
EmployeeName
Q1Rating
Q1Score
....
Q10Rating
Q10Score
Scores:
ScoreID
Rating
Score
I have tried using an OnChange function etc on the form, but can not
get it to work. Can anyone please point me in the right direction of
the best way to tackle this?
Thanks in advance!
2  1686  MMcCarthy 14,534
Recognized Expert Moderator MVP
Don't store the score in the results table, just the rating. You can then use DLookup in an unbound textbox on Form to show the score for each rating
 Rabbit 12,516
Recognized Expert Moderator MVP
Hey Everyone,
I am a bit of a noob at this, but have to build this database and
would love some help if anyone can provide any. I have a database
designed at capturing customer satisfaction surveys. I have a table
that captures answers to several different questions, ie;
Q1 - Rating (either Excellent, Good, Average, Poor)
Q1 - Score (either 10, 6.7, 3.3, 0)
The score corresponds with the text rating, these are then compiled to
give an average result for each question, for each staff member over a period of time.
The problem I am having is getting the "Score" to update automatically
depending on the result given in the "Rating" answer.
My table structure is basically like this:
SurveyResults:
SurveyID
CustomerName
EmployeeName
Q1Rating
Q1Score
....
Q10Rating
Q10Score
Scores:
ScoreID
Rating
Score
I have tried using an OnChange function etc on the form, but can not
get it to work. Can anyone please point me in the right direction of
the best way to tackle this?
Thanks in advance!
Seeing as how Score is related to Rating, you don't need to store both, just store the Score and you can translate to rating later when you need it.
If you want to show it on the form you can just use a textbox and use the After Update event of Score to display the rating.
What code did you try in the On Change? I'm thinking you'd use SELECT or PARTITION.
Sign in to post your reply or Sign up for a free account.
Similar topics | |
by: John Sheppard |
last post by:
Hi there
Does anyone know how to fill a bound textbox automaticlly.
In an unbound textbox I would put in the control source =Sum(price, tax) (or
some such function) and access updates it automaticlly.
Is there a way to do the same thing on a bound textbox so that it is
automaticly updated?
|
by: Danny J. Lesandrini |
last post by:
I searched Google but couldn't find any reference to this one, though
I've observed the behavior before.
The current case is where I select a value in a combo box, which has
a Long Integer as it's bound value. After updating this value and moving
to the next record, the field directly after the combo gets populated with
the same value as the bound column of the combo.
There is no code in the form putting this there. Any ideas?
|
by: Sami |
last post by:
Please bear with me, and if you answer this question, please do it
step by step. I am new at Access, not at all sophisticated. I am
using Office XP. This will need to be read in Access for Office 2000.
I am creating a database to track student athletes. I have created
the following tables. The table title is to the far left, with fields
under each. The common field will be the StudentID field, which is
their student number assigned...
|
by: HD |
last post by:
Hello. For the following, I would appreciate if anyone could tell me:
if it can be done, how it might done, and/or what search terms I could
use to find the solution myself.
I would like to create a database in which _adding a new record
automatically creates a new field in the table_ (ideally, deleting a
record would also delete the field that was created when that record
was added). Thus, the number of fields in the table would...
|
by: prime80 |
last post by:
I'm building a project database to keep track of the various
engineering projects ongoing in our department. These projects will be
grouped by priority (=High, Medium, Low) and ranked within
the priority (=1,2,3,etc.). What I'd like for it to do is
automatically update rankings when a project rank is changed, a new
project comes in, or a project is completed. For example, let's say
there are 4 high priority projects. If High #2 is...
| | |
by: Lars Netzel |
last post by:
A little background:
I use three Datagrids that are in a child parent relation.
I Use Negative Autoincrement on the the DataTables and that's workning nice.
My problem is when I Update these grid and write to the database and I set
the new Primary Keys and related Fields to the new asigned atuonumbers in
the Access.
|
by: froglog |
last post by:
I have created a MS access DB to track transport costs for tax purposes.
I enter data into a main form that tracks miles traveled by date with a subform . The subform has fields for the date traveled , toll location and the cost of the toll . The date on the subform is copied from the main form. is a combo box that draws its values from in the table, which also has the fields -Toll ID, Toll text, and toll cost).
My question is...
|
by: Kassimu |
last post by:
I need to update the memo field in the access table. I have unbound form frmNewEntry with two text boxes , and one command button cmdSave. Usually the user opens the frmNewEntry to add new information when s/he presses cmdSave the content of is added to the memo field of the table tblMasterOrders whose record ID equals to the value in . Furthermore I need additional information added as well; Current user and time and date with line break as...
|
by: Kitty001 |
last post by:
Hi Guys
I am new to MS Access and using MS Access2007.
I have been fooling around with Access trying to solve this problem for weeks but i just cant seem to chack it and I need some help.
I have a database based on the machines used for the maintenance of a golf course here in South Africa.
I have tables containing the "Groups of Machines", "Machines" and the "Types of Fuel" they use with Prices per Lt.
I have created a form thats been...
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look !
Part I. Meaning of...
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it.
First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
| | |
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth.
The Art of Business Website Design
Your website is...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
|
by: conductexam |
last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one.
At the time of converting from word file to html my equations which are in the word document file was convert into image.
Globals.ThisAddIn.Application.ActiveDocument.Select();...
|
by: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols.
I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
|
by: 6302768590 |
last post by:
Hai team
i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
| | |
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
| |
