表单：根据日期范围在表单上自动填充字段 [英] Forms: Fill a Field automatically on a form based on a date range

问题描述

我有一个员工假期数据库，里面有一张假期表，

有员工姓名，工资周和假期。我有另一张

查询表，其中包含一周的付费周代码和日期范围。用户

想在假期日期字段中输入日期，并自动填写

支付周字段。我的dlookup代码无效。

以下是表格的示例：


员工：姓名

支付周

日期假期


PayWeek：PW日期范围

06 06/05/06 - 06/09/06

07 06 / 12/06 - 06/16/06


当我在表格中输入日期

时，我无法工作假期06/07/06并在表格中自动输入06表格支付周

字段。任何帮助，将不胜感激。谢谢。

Hi, I have a employee vacation database that has a vacation table that
has the employee name, pay week and date of vacation. I have another
lookup table with pay week code and date range for the week. The user
would like to type in a date in the Date of Vacation field and have the
Pay Week field automatically fill in. My dlookup code is not working.
Here is example of what the tables look like:

Employee: Name
Pay Week
Date of Vacation

PayWeek: PW Date Range
06 06/05/06 - 06/09/06
07 06/12/06 - 06/16/06

I can''t get it to work when I enter on the form a date in the Date of
Vacation 06/07/06 and have the form automatically put in 06 in Pay Week
field. Any help would be appreciated. Thanks.

推荐答案

我们需要查看更多信息。你试图使用的sql

作为一个开始是有帮助的..

We need to see more information. The sql that you are attempting to use
would be helpful as a start..

这些日期真的是一个单一的文本字段，日期范围？合并？

Are those dates really in a single text field, Date Range? Combined?

是的，它们是单个文本字段。


w_a_n_n_a_l_l_-@-_s_b_c_g_l_o_b_a_l._n_e_t写道：

Yes, they are a single text field.

w_a_n_n_a_l_l_-@-_s_b_c_g_l_o_b_a_l._n_e_t wrote:

这些日期是否真的在一个文本字段中，日期范围？合并？

Are those dates really in a single text field, Date Range? Combined?

这篇关于表单：根据日期范围在表单上自动填充字段的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！