Question Not sure what type of expression/condition I need

[spaghetti]

Hello all, I am a newbie to this forum so I hope this is the right place to ask my question.

I need to add some conditions to a table or query. They are feedback scores from training events. They are returned from the assessor as 3 lots of scores between 0-4 and input next to the persons name to say that they have attended and to show how satisfied they are with the trainer, the training material and if they think this will have an impact on their work. These are held on a Delegates Table and are listed as Satisfaction Score, Trainer Score and Impact Score. I have been asked to convert the 0-4 scores into percentages in a table which will eventually feed through to a report. They are: 1=25%, 2=50%, 3=75% and 4=100%. Try as I might I cannot get this to work the way I need it too and I am spending way too much time on this so any help would be appreciated. I am working on Access 2007 so I can't add a calculated field to the original table so does this have to be an expression in a new query? I have tried an IIF expression but that hasn't worked.

Any advice would be appreciated.

Cheers.

 

[AOB]

Just switch the actual scores with a calculated version when running the query to populate the report

So instead of

SELECT [Satisfaction Score]
FROM [Delegates Table]

Use

SELECT ([Satisfaction Score]*25/100) AS [Satisfaction Percentage Score]
FROM [Delegates Table]

Don't store the same information twice (i.e. the original 1 to 4, as well as the modified 25%-100%) if you can store it once and generate the required result with a query!

 

[spaghetti]

Hello AOB,

Thank you for helping me. I have tried to add that to the code and it's not running. It says there is a Syntax error in the query expression. Have I added it in the right place? I'm not all that familiar with working with code.

SELECT [Delegates Table].[Event Code], [Monitoring Sheet].[Event Title], [Monitoring Sheet].Date, [Delegates Table].Surename, [Delegates Table].Forename, [Delegates Table].Provider, [Delegates Table].Region, [Delegates Table].Attended, [Delegates Table].([Satisfaction Score]*25/100) AS [Satisfaction Percentage Score],[Delegates Table].[Trainer Score], [Delegates Table].[Impact Score], (Nz([Satisfaction Score])+Nz([Trainer Score])+Nz([Impact Score]))/3 AS ScoreTotal
FROM [Delegates Table] INNER JOIN [Monitoring Sheet] ON [Delegates Table].[Event Code] = [Monitoring Sheet].[Event Code]

 

[AOB]

[COLOR=red][B]([/B][/COLOR][Delegates Table].[Satisfaction Score]*25/100[B][COLOR=red])[/COLOR][/B]

 

[spaghetti]

I've got it to work! I left off the brackets and it worked! It's a fab - thank you!