IIF or CASE WHEN function

Hi

I'm connecting to an MS ACCESS database table call Answers. I want to make a
gridview where one of the columns will state if the user answered a question
correctly or not. In the MS ACCESS data source I'm trying to get the IIF
function to return either 'correct' or 'incorrect' by comparing the
CorrectAnswer field to the SuppliedAnswer, like so:
IIF(CorrectAnswer=SuppliedAnswer, 'Correct','Incorrect'). However the query
builder in VWD changes the syntax to IIF('CorrectAnswer=SuppliedAnswer',
'Correct','Incorrect') which always returns 'Correct' which is wrong. If I put
the field name between [] the same thing happens.

I have also tried the following: CASE WHEN SuppliedAnswer = CorrectAnswer THEN
'Correct' ELSE 'Incorrect' END but when I execute the query it get an
iErrorInfo.GetDescription Failed with E_Fail(0x80004005)

Please help

 

Thanks

David

Don't work in Access much, so this is a guess.

After the CASE statement, did you provide an alias for that value?  Because if
you did not, that might be the reason the GetDescription didn't work.

Sorry, the full case statment goes: CASE WHEN SuppliedAnswer = CorrectAnswer
THEN 'Correct' ELSE 'Incorrect' END As EXPR1

You could try creating the IIF query within Access, then save it with a
meaningful name.  Then call it as if it were a stored proc in SQL Server.
(Command.CommandType = CommandType.StoredProcedure).  Case is not supported by
Access/Jet. The VWD query builder is not very good with Access.

Thanks for that. Do you perhaps have a VB example of how to do that. Currently
I'm just dragging MS Access data connections onto the form and not really
working the connections in code - which I would prefer to do