Query (if Statement I Think?)

[Hello World]

I have a table with these two fields: ‘Answer’ and ‘RevisedAnswer’. Both draw their values from the same look-up.

Hi,

I have some data in each field in a table which looks something like this. Both draw their values from the same look-up.

FirstAnswer RevisedAnswer

1. Yes No
2. No
3. No Yes
4. No Yes
5. Yes

What I would like to do is have a report which reports on the latest state of play regarding how people have answered (how many people have said yes or no). But crucially if people have revised their answer then I need this to take precedence over their first answer. For example the final report on the above would state that 2 people have said ‘No’ and 3 people have said ‘Yes’.

I suppose what I require is some code which states that if the first answer column has data in it and the revised answer column is null then take the first answer column BUT if both fields have data in them then take the revised answer column.

Ultimately I would like the query to count how many people have said yes or no.

Hoping that makes sense.

[hertfordkc]

Create a query which includes both columns, then add a calculated column (FnlAnsr) which is a if statement. After you test that query, then add the totals.

[Hello World]

Thanks Hertford,

Any idea what that If statmenet would be?

[rpeare]

iif(not isnull(revisedanswer), revisedanswer, firstanswer)

This will give you the revised answer if it's present, otherwise it will give you the first answer.