是的。创建这样的查询:
SELECT DISTINCT
[Tens]+[Ones] AS Factor,
10*Abs([Deca].[id] Mod 10) AS Tens,
Abs([Uno].[id] Mod 10) AS Ones
FROM
msysobjects AS Uno,
msysobjects AS Deca;
将其另存为qdyFactor。然后创建此查询:
SELECT DISTINCT
DateAdd("d",[Factor],[DateFrom]) AS Dates
FROM
qdyFactor
WHERE
qdyFactor.Factor Between 0 And DateDiff("d",[DateFrom],[DateTo]);
这将创建日期列表。最后,使用它来过滤和汇总其他表。