error with inside an iif

Posted on 2009-04-15
Medium Priority
Last Modified: 2012-05-06
Hi Guys

This is driving me crazy
Event: "Eval  " & IIf(([EvaluationDetails].[EvaluationType]=Mutation),[EvaluationDetails].[EvaluationType]&-&[EvaluationResultsDetails].[EvaluationSubtype]&-&[EvaluationResultsDetails].[EvaluationMeasurement]&=&[EvaluationResultsDetails].[ EvaluationResultsValue],[EvaluationDetails].[EvaluationType]&-&[EvaluationResultsDetails].[EvaluationSubtype]&-&[EvaluationResultsDetails].[ EvaluationResultsValue])&" Prog = "&[OverallProgression]
When i use " " , it's telling me [Enter Parameter Value] ["]
then when i change it to ' ', works and then said the same, [Enter Parameter Value] ['], and viceverse
Any comment, please advice
Question by:titorober23
1 Comment

Accepted Solution

titorober23 earned 0 total points
ID: 24151601
Event: "Eval  " & IIf(([EvaluationDetails].[EvaluationType]='Mutation'),[EvaluationDetails].[EvaluationType] & "-" & [EvaluationResultsDetails].[EvaluationSubtype] & "-" & [EvaluationResultsDetails].[EvaluationMeasurement] & "=" & [EvaluationResultsValue],[EvaluationDetails].[EvaluationType] & "-" & [EvaluationResultsDetails].[EvaluationSubtype] & "=" & [EvaluationResultsValue]) & " Prog = " & [OverallProgression]

Featured Post

Free Backup Tool for VMware and Hyper-V

Restore full virtual machine or individual guest files from 19 common file systems directly from the backup file. Schedule VM backups with PowerShell scripts. Set desired time, lean back and let the script to notify you via email upon completion.  

Question has a verified solution.

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

It is possible to export the data of a SQL Table in SSMS and generate INSERT statements. It's neatly tucked away in the generate scripts option of a database.
This article shows how to get a list of available printers for display in a drop-down list, and then to use the selected printer to print an Access report or a Word document filled with Access data, using different syntax as needed for working with …
Do you want to know how to make a graph with Microsoft Access? First, create a query with the data for the chart. Then make a blank form and add a chart control. This video also shows how to change what data is displayed on the graph as well as form…
Visualize your data even better in Access queries. Given a date and a value, this lesson shows how to compare that value with the previous value, calculate the difference, and display a circle if the value is the same, an up triangle if it increased…

839 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