Search results

I'm not quite sure what code tags are... but here are the equations for the three percentages: PercentChoiceMiss...

So I think I need an If, then statement in my query for each of the three percents equations, something along the line If it is #Num! (that's the error I'm getting), then put "0". Can this be done? Thanks for your help!

I changed it to: Dim vPercentChoiceMiss As Double Dim vPercentExposureMiss As Double Dim vPercentCorrect As Double but still come up with the Overflow error. :( Do all the other parts of the code look correct? Do you think it just has to do with that part in the beginning? Thank you again...

I don't have any Div/0 in my dataset, but I do have #Num! (when 0/0), which should just be 0. Everything was working fine until I added this: "Dim vPercentChoiceMiss, vPercentExposureMiss, vPercentCorrect as String". In the query, these answers are where I have #Num!. The answers to these...

I'm trying to add columns to a macro, and in the design view everything looks correct, but I'm getting an Error #6: Overflow. I added the columns "PercentExposureMiss", "PercentChoiceMiss" and "Percent Correct". It was working fine before these additions. Does anyone see a problem with the...