Iif功能 [英] Iif Function

问题描述

您好我已经为我的孩子做了很多项目，这次我想做一个数学测验但我不知道如何使用（iif）函数为这个项目。让我看看我能解释这个权利，因为我上次有一个形式领导者在最后的项目帮助我，他很酷，不记得他的名字，但如果他读这个他会知道我有一个表格，我有三个文本框：


1 - Number1

2 - Number2

3 - Useranswer（确定如果用户在正确输入时获得正确答案或错误答案）

>

我有一个名为next的按钮（这个按钮生成随机数字）


我需要计算一下他们有多少他们做对了多少他们弄错了我是否使用两个文本框？如果是这样我怎样才能使用（iif）函数来计算它？


Lee 123

解决方案

在我看来，你可以只使用一个查询来计算在测试结束时孩子们在测试中得到的正确和错误答案，你可以从查询中获得简单的报告，它应该告诉他们有多少权利和错误。

我想要使用iif文本框的控制源中的功能（正确）和（不正确）但不知道如何建议它。我不想要一个查询，我想让他们看到他们有多少是正确的，有多少他们弄错了。表格

有没有人可以提供帮助！

Hi There I''ve Been Doing Alot Of Projects For My Kids And This Time I Wanted To Do A Math Quiz But I Cant Figure Out How To Use The ("iif") Function For This Project. Lets See If I Can Explain This Right Because Last Time I Had A "formleader" Help Me On The Last Project And He Was Cool Can''t Remember His Name But If He Reads This He''ll Know Any Way I Have A Form And I Have Three Text Boxes:

1 - Number1
2 - Number2
3 - Useranswer (determins If The User Gets The Answer Right Or Wrong When He Presses Enter)


And I Have A Button Named "next" ( This Button Generates Random Numbers)


I Need Someway To Count How Many They Get Right And How Many They Get Wrong Do I Use Two Text Boxes? If So How Can I Use The ("iif") Function In Them To Count This?

Lee 123

解决方案

it seems to me you can just use a query to count how many right and wrong answers ure kids get on the test at the end of the test you can just get simple report off a query and it should just tell them how many right and wrong.

Well I Wanted To Use The "iif" Function In The Control Source Of The Textboxes ( Correct) And ( Incorrect) But Don''t Know How To Aproach It. Don''t Want A Query I Want Them To See How Many They Get Right And How Many They Get Wrong.on The Form

is there anybody out there who can help!

这篇关于Iif功能的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！