是否可以在 MS Access 中生成每次运行查询时都不会改变的随机数？

发布于 2024-11-10 02:56:11 字数 226 浏览 8 评论 0原文

我正在尝试从 Microsoft Access 数据库中随机提取 200 条记录。我创建了一个查询，并在新字段中使用 rnd() 函数为每条记录生成一个随机数。然后我对随机数字段进行排序并检索了前 200 篇文章。我的问题是，每次运行查询时，我都会得到不同的随机数。我知道在其他程序中，您可以为种子设置用户定义的值，并且此问题将得到解决，但是我不知道如何在 MS Access 中自己设置种子值。这可以吗？

感谢您的帮助！

原文

分享到QQ

分享到微博

如果你对这篇内容有疑问，欢迎到本站社区发帖提问参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。

发布评论

需要登录才能够评论，你可以免费注册一个本站的账号。

羁客 2024-11-17 02:56:11

您是否尝试阅读 Rnd() 函数的 Access 帮助？该函数有一个参数，帮助文件定义了种子的作用：

   If number is            Rnd generates 
   Less than zero          The same number every time, using number as the seed. 
   Greater than zero       The next random number in the sequence. 
   Equal to zero           The most recently generated number. 
   Not supplied            The next random number in the sequence.

因此，您希望在每次运行查询时传递一个对每行都相同的负数。自动编号 PK 将是一个理想的候选者，因为它是唯一的 - 只需使用 Rnd(-MyPK)。

唯一的问题是，如果您使用随机自动编号，在这种情况下，某些数字已经是负数，因此您会遇到问题。我没有一个好的解决方案来避免冲突（即，两行产生相同的值，因为它们具有相同的绝对值）并且不会导致溢出。

Did you try reading the Access help for the Rnd() function? The function has a single argument, and the help file defines what the seed does:

   If number is            Rnd generates 
   Less than zero          The same number every time, using number as the seed. 
   Greater than zero       The next random number in the sequence. 
   Equal to zero           The most recently generated number. 
   Not supplied            The next random number in the sequence.

So, you want to pass a negative number that is the same for each row each time you run the query. An Autonumber PK would be an ideal candidate for that, since it will be unique -- just use Rnd(-MyPK).

The only problem would be if you are using random Autonumbers, in which case some of the numbers would be negative already, so you'd have a problem there. I don't have a good solution to that that would avoid collisions (i.e., two rows producing the same value because they have the same absolute value) and that wouldn't lead to an overflow.

回复收藏 0 原文