I am working on a survey with the rankings as 1 - with an assigned value of 0, 2 with an assigned value of 25, 3 - with an assigned value of 50, 4 - with an assgined value of 75 and 5 - with an assigned value of 100. when i bring this over into my report from the query, i get the right answer of just a few of them. This is what I have in my query for one of the questions. Expr1: IIf([ertimebeforeseen]=1,0,IIf([ertimebeforeseen]=2,25,IIf([ertimebeforeseen]=3,50,IIf([ertimebeforeseen]=4,75,IIf([ertimebeforeseen]=5,100)))))
What's wrong??? I am so new to this and learning on my own! Do I need an = sign in front with the DCOUNT, of SUM??? Please help!!! lrdutches@aol.com
What's wrong??? I am so new to this and learning on my own! Do I need an = sign in front with the DCOUNT, of SUM??? Please help!!! lrdutches@aol.com