Query to Add two fields

[murray83]

Hi All

I have the below query which is running fine but i want it to total ( some how ) so it should show 3 ( as when they use a joker they get a bonus if the answer was correct )

query ran

query details

so any help be grateful appreciated

cheers all

 

[theDBguy]

Show a total of 3 in which column? How does the total of 3 gets calculated from the data you posted? Is it by subtracting the first record to the second record in ChoiseNo column?

 

[plog]

Agree with Dbguy, there's no way to do addition on those 2 records to arrive at the answer of 3.

Are you summing Yes/No fields? How can you play a negative amount of Jokers? How can you get a negative amount of answers correct?

 

[Gasman]

Choise ?

 

[Pat Hartman]

Choise ?

I had a programmer on my team who couldn't spell to save himself. The team took a vote and we had him fix all his spelling errors because it drove the rest of us crazy if we had to work on his code. This was back in the days of punched cards so it was no simple task as it is to day with something like find and replace.

 

[MajP]

I am assuming you want the number of questions correct for a person for a round + 1 if the answer is correct and they played a joker If that is what you want you can do that in a subquery, but I would make separate query and link that to your query by both RoundNo and Person

Assume two people played round 1 which has three questions.

Player 1 answered 2 questions and none correct with a joker
Player 2 answered 2 questions correct and one with a joker played.


Then your query to get the sum for each person per round (+ 1 for correct with joker)

You can then join that query to your original query getting something like

 

[GPGeorge]

I had a programmer on my team who couldn't spell to save himself. The team took a vote and we had him fix all his spelling errors because it drove the rest of us crazy if we had to work on his code. This was back in the days of punched cards so it was no simple task as it is to day with something like find and replace.

Back in the days when cruel and unusual punishment was still legal?