未来日期 [英] Future Date

问题描述

1。我正在使用Access 2007

2.我是一个新手所以请善待

3.我有一个字段ISRT_Opened_date

4.我需要将45个工作日计算到一个名为dpe_due_date的未绑定文本框


我一直试图将此公式放在未绑定的tex框的控件源中，名为dpe_due_date

1. I am using Access 2007
2. I am a total novice so be kind please
3. I have a field ISRT_Opened_date
4. I need to calulate 45 work days out to a unbound text box called dpe_due_date

I have been trying to put this formula in the control source of the unbound tex box called dpe_due_date

推荐答案

什么是工作日就你而言？


你谈论一个TextBox（一个表单控件），然后你谈论一个字段（一个用于保存数据的Table元素）。这两个概念不兼容。我们真的只是在谈论表单上的两个控件，其中一个绑定但另一个不绑定？

What is a "work day" as far as you''re concerned?

You talk about a TextBox (a Form Control), and you talk about a field (a Table element for holding data). These two concepts are not compatible. Are we really just talking about two controls on a form where one is bound but the other is not?

我有一个开始日期的字段，我想添加一个字段到截止日期表。我将在60天内运行查询和报告截止日期。

I have a field for the start date, I would like to add a field to the table for the due date. I will be running query and reports for due dates within 60 days.

这不回答我的问题大卫:-(


它确实会提高如果截止日期是通过算法确定的（如你所暗示的那样），你为什么要为自己增加一个额外的字段呢？

That answers neither of my questions David :-(

It does raise another though. If the due date is determined algorithmically (as you''ve implied), why would you want to burden yourself with an extra field for it?

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