MS Access计算文本框出现问题 [英] Problem with MS Access calculated text box

问题描述

我有一个数据库，我需要运行一个项目报告？过期？或？未完成？我需要设置一个新字段（状态），以便它可以告诉我项目是否过期或未完成。我正在做一个计算文本框，在文本框内我首先输入以下内容：


= IIf（（[通过电子邮件发送日期查询] + [响应时间]）< = [Response收到]，逾期，未完成）


但是，这并未在状态字段中输入准确信息。例如。我有按时回复的物品，但它们是否会出现？没有推荐？


然后我尝试了以下内容：

= IIF（ （[收到回复]< =（[通过电子邮件发送询问日期+ [响应时间]），？逾期？，？未完成？）

但是这回复为：您输入的表达式包含无效您可能在没有操作员的情况下输入了操作数。


任何人都可以看到我哪里出错了或者给我任何建议吗？


谢谢你

I have a database which I need to run a report of items which are ?Overdue? or ?Not completed?. I need to set up a new field (status) so that it can tell me if an item is Overdue or not completed. I was doing a calculated text box and inside the text box I entered the following first:

=IIf(([Date emailed enquiry]+[Response time])<=[Response Received],"Overdue","Not completed")

However this was not entering accurate information in the status field. E.g. I had items which were responded to on time, however they were coming up as ?Not comleted?.

I then tried the following:
=IIF(([Response received]<=([Date emailed enquiry]+[Response time]),?Overdue?,?Not completed?)
But this comes back as: The expression you entered contains invalid syntax. You may have entered an operand without an operator.

Can anyone see where I am going wrong at all or offer me any advice?

Thank you

推荐答案

你能告诉我字段的值和字段格式：[发送电子邮件的日期查询]，[响应时间]，[收到的响应]你在表中引用了吗？我怀疑你的问题就在那里。

can you show me the values and field formats for the fields : [Date emailed enquiry],[Response time],[Response Received] that you are referencing in the table? I suspect your problem lies there.

感谢你的回复，它们都是除了[响应时间]之外的日期格式，这是1到14之间的数字。


我有一个名为[Reply due by]的字段，这是一个计算字段，可以工作o ut by = [[通过电子邮件发送日期查询] + [响应时间]


我需要的是一个新状态，其状态会让我过期或未完成或当我找到[回复时] [回复到期]


希望这是有道理的。

Thanks for your response, they are all date formats apart from [Response time] which is a number between 1 and 14.

I have a field called [Reply due by] which is a calculated field and that is worked out by =[Date emailed enquiry]+[Response time]

And what I need is a new field with status which will give me "Overdue" or "Not completed" when I work out [Response Received] against [Reply due by]

Hope this makes sense.

= IIf（（[通过电子邮件发送询问的日期+ [响应时间]）< = [收到的响应]，逾期，未完成）


但是，这并未在状态字段中输入准确的信息。例如。我有按时回复的物品，但是它们会出现？没有说明？

=IIf(([Date emailed enquiry]+[Response time])<=[Response Received],"Overdue","Not completed")

However this was not entering accurate information in the status field. E.g. I had items which were responded to on time, however they were coming up as ?Not comleted?.

你能解释一下你在这里想做什么吗？该陈述只有两种可能的答复：逾期或未完成。如果按时收到回复，您希望发生什么？

Can you explain what you''re trying to do here? That statement only has two possible responses: overdue or not completed. What do you want to happen if the response was received on time?

这篇关于MS Access计算文本框出现问题的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！