选择N并在Access中随机显示N行

Question

我需要从一个简单的查询中选择特定数量的随机行。该编号以([Formulários]![Survey]![SelectSurveySample])的形式指定。如果我尝试选择前5名，它是有效的，但我想在表格中更改这个数字。

SELECT TOP ([Formulários]![Survey]![SelectSurveySample]) *
FROM [main_table] mt
WHERE (((mt.CPA_Number)=[Formulários]![Survey]![selectCPA_Survey]) 
AND ((mt.Sample_Household)=False) AND ((mt.Functionality_Survey)=False))
ORDER BY rnd(Int(Now*ID)-Now*Id)

Answer 1

是否尝试删除括号。。。

SELECT TOP [Formulários]![Survey]![SelectSurveySample] *
FROM main_table
WHERE (((main_table.CPA_Number)=[Formulários]![Survey]![selectCPA_Survey]) 
AND ((main_table.Sample_Household)=False) 
AND ((main_table.Functionality_Survey)=False))
order by rnd(Int(Now*ID)-Now*Id)

由于这适用于更改为SELECT TOP 5，并且查询中有一个表单变量[Formulários]![Survey]![selectCPA_Survey]，所以我看到的唯一区别是括号。