日期和日历帮助！ [英] Date and Calendar help!

问题描述

我使用这个网站为我当前的工作设计了一个数据库，用于跟踪我们的分析师的活动。我已经使用这个网站解决了我所有的VBA问题。谢谢！我只是遇到了最后一个问题。


基本上，我希望分析师在表单中选择活动日期，Access会识别它所涉及的付费期。我该怎么做呢？我有一张表格，显示了开始付款期限日期和结束付款期限日期。这是一个简单的dlookup吗？我输了，任何帮助将不胜感激。


我为这个例子添加了一张表。提前致谢！

可以

附加文件

（18.4 KB，48次观看次数）

Smiley'的第2行可以写成：

展开 | 选择 | 换行 | 行号

Ive used this website to design a database for my current job that tracks the activities of our analyst. I have solved all my VBA problems using this website. THANKS! I just having one last problem.

Essentially, I want the analyst to choose a date of their activity in a form and Access recognize what pay period it falls into. How do I do this? I have a table which shows the Beginning pay period dates and ending pay period dates. Is this a simple dlookup? Im lost, any help would be appreciated.

I attached a table for the example. Thanks in Advance!
Can

Attached Files

Pay Period - Test.zip (14.7 KB, 63 views)

解决方案

Should be a simple matter. Lets assume dt_WorkDate is the variable containing your work date, and your work period table has a primary autonumber key named KEY_Period.


This would be the example to go with that:

Expand|Select|Wrap|Line Numbers

Or test using a query:

Attached Files

Pay Period - Solve 1.zip (18.4 KB, 48 views)

Smiley''s line #2 could be written as :

Expand|Select|Wrap|Line Numbers

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