Access 2007随机时间表 [英] Random Schedule for Access 2007

问题描述

我需要帮助，我以前从未尝试过这样的事情。我已经设置了一些表格，查询和表格。我需要帮助的是每周为每个类别/班次挑选一定数量的人名。


来自LVL 1我每周每班需要1个人（从第1名，第2名和第3名需要5名。


来自lvl 2 I需要每周2次


来自LVL 3需要每周1次。


然后我会创建一份报告发送出去。 />

我已经附上了迄今为止所做的事情。


提前致谢。

I need help, I have never tried anything like this before. I have set up some tables, queries and forms. What I need help with is picking peoples names at a certain quanity for each category/shift per week.

From LVL 1 I need 1 person per shift per day per week(5 from 1st, 2nd and 3rd.

From lvl 2 I need 2 per week

From LVL 3 need 1 per week.

Then I''ll create a report to send out.

I have attached what I have done so far.

Thanks in advance.

附加文件

新的LPA Audit.zip （188.0 KB，58 views）

Attached Files

New LPA Audit.zip (188.0 KB, 58 views)

推荐答案

对不起，我没有下载并打开我不知道的人的附件。但是您可以使用Rnd（）函数并使用时间因子和唯一键将其播种。如果您按此排序并仅采用您需要的前n个记录，那将为您提供所需的随机选择。

Sorry, I don''t download and open attachments from people I don''t know. But you can use the Rnd() function and seed it with a time factor and a unique key. If you sort by that and take only the first n records that you need, that will get you the random selection you need.

如上所述，从未做过随机计划，我什么都不知道关于Rnd（）或放置它的位置或时间因素或唯一键。设置完成后，我需要它作为一个宏运行，这样我的用户只需点击一个按钮就可以输出到报告中，然后在公司邮寄出来。


谢谢，


DJRhino

As stated above, never done a random schedule, I know nothing about a Rnd() or where to put it or what time factor or unique key. When this is set up I need it to run as a macro so my user can just click a button and have it output to a report to be mailed out with in the company.

Thanks,

DJRhino

我也忘了添加我们有一个它需要拉出的假期列表所以它没有安排任何人那些日子。

I also forgot to add that we have a holiday list that it needs to pull from so it doesn''t schedule anyone on those days.

这篇关于Access 2007随机时间表的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！