如果，那么语法错误 [英] If, then syntax error
问题描述
好的，我已经阅读了关于这个问题的一些其他问题，我只是特别密集，因为我似乎无法弄清楚如何做到这一点。
好的一些背景我已经继承了一个理想情况下没有设置的Access数据库，但没关系。我跟踪律师的继续教育。
我已经制作了一份报告，跟踪特定时间段内的所有要点。现在很多时候我们都知道律师已经上课了，有多少分值，但是我们没有证明他们参加过的证书。我已经写了我的报告，所以在报告页脚中它总结了tehy所获得的所有不同点。但我不想要它总结所有这些我只想要它总结我有证书的那些。
我试着写这个：
IIf（[证件上的文件] =真=总和（[等等等等]]
但它告诉我基本上我需要一些真正的和=我希望得到的总和。我知道如何拥有它只是给我那些我有证书，但我想看到系统中的所有那些在两个日期之间，但只有总和的那些有一个证书
我希望我没有彻底混淆这个问题。请帮助!!
好的我已经阅读了关于这个问题的一些其他问题，我只是特别密集，因为我似乎无法弄清楚如何做到这一点。
好的一些背景我已经继承了一个没有理想设置的Access数据库，但没关系。我跟踪co对律师进行ntinuing教育。
我做了一个报告，跟踪特定时间段内的所有要点。现在很多时候我们都知道律师已经上课了，有多少分值，但是我们没有证明他们参加过的证书。我已经写了我的报告，所以在报告页脚中它总结了tehy所获得的所有不同点。但我不想要它总结所有这些我只想要它总结我有证书的那些。
我试着写这个：
IIf（[证件上的文件] =真=总和（[等等等等]]
但它告诉我基本上我需要一些真正的和=我希望得到的总和。我知道如何拥有它只是给我那些我有证书，但我想看到系统中的所有那些在两个日期之间，但只有总和的那些有一个证书
我希望我没有彻底混淆这个问题。请帮助!!
尝试输入它这在你的文本框中：
= IIf（[证书上的文件] =真，总和（[blah blah blah]））
尝试在你的文本框中输入：
= IIf（[证书上的文件] =真，总和（[等等等等]） ）
它告诉我语法错误（缺少操作员）
我也尝试过和Cert一起使用额外的一组（）文件和真实
在哪里？ ;否则"声明部分公式？
= IIf（[证书上的文件] =真，总和（[blah blah blah]，""））
Ok I''ve read through some other questions on this one and I''m just being particularly dense because I can''t seem to figure out how to do this.
Ok some background I''ve inherrited an Access database that is not ideally set up but it is ok. I keep track of continuing education for lawyers on it.
I have made a report that tracks all the points through a specific time frame. Now many times we know the attorney has taken a class and how many points it is worth but we don''t have the certificate proving they attended yet. I''ve writen my report so that at the report footer it sums all the different points tehy have earned. But I don''t want it to sum all of them I only want it to sum the ones that I have a certificate for.
I tried writing this:
IIf([CERTIFICATE ON FILE]=True =Sum([blah blah blah)]
but it tells me basically I need something between the True and =Sum which I would like to be a than. I know how to have it just give me the ones I have a Certificate on but I want to see all the ones in the system between the 2 dates but only the totals for the ones with a cert.
I hope I haven''t thoroughly confused the issue. Please help!!
Ok I''ve read through some other questions on this one and I''m just being particularly dense because I can''t seem to figure out how to do this.
Ok some background I''ve inherrited an Access database that is not ideally set up but it is ok. I keep track of continuing education for lawyers on it.
I have made a report that tracks all the points through a specific time frame. Now many times we know the attorney has taken a class and how many points it is worth but we don''t have the certificate proving they attended yet. I''ve writen my report so that at the report footer it sums all the different points tehy have earned. But I don''t want it to sum all of them I only want it to sum the ones that I have a certificate for.
I tried writing this:
IIf([CERTIFICATE ON FILE]=True =Sum([blah blah blah)]
but it tells me basically I need something between the True and =Sum which I would like to be a than. I know how to have it just give me the ones I have a Certificate on but I want to see all the ones in the system between the 2 dates but only the totals for the ones with a cert.
I hope I haven''t thoroughly confused the issue. Please help!!try entering it like this in your textbox :
= IIf([CERTIFICATE ON FILE]=True, Sum([blah blah blah]))
try entering it like this in your textbox :
= IIf([CERTIFICATE ON FILE]=True, Sum([blah blah blah]))it tells me Syntax Error (missing operator)
I''ve also tried that with and extra set of () around Cert on file and true
Where is the "else" statement part of the formula?
= IIf([CERTIFICATE ON FILE]=True, Sum([blah blah blah],""))
这篇关于如果，那么语法错误的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
