我正在Access 2010中工作。我有以下查询（名为bird_year_species）：
SELECT sub.Species, Min(sub.obs_year) AS First_sighting_year
FROM (SELECT DISTINCT [Genus_BiLE] & " " & [Species_BiLE] AS Species, [Year_BiLE] AS obs_year
FROM BiLE_Bound
UNION ALL
SELECT DISTINCT [Genus_BiMN] & " " & [Species_BiMN] AS Species, [Year_BiMN] AS obs_year
FROM BiMN_Bound
UNION ALL
SELECT DISTINCT [Genus_BiPC] & " " & [Species_BiPC] AS Species, [Year_BiPC] AS obs_year
FROM BiPC_Bound
UNION ALL
SELECT Distinct [Genus_BiOP] & " " & [Species_BiOP] AS Species, [Year_BiOP] AS obs_year
FROM BiOP_Rec
) AS sub
GROUP BY sub.Species;
当我打开它时，会弹出一个对话框，询问Query1.obs_year的参数值。如果我只填写任何内容，然后单击确定，便会弹出表格，它可以正常工作。我不知道为什么会这样，并且查询未命名为Query1。
我尝试将代码复制到新查询中。我尝试压实修理。我尝试用其他名称保存数据库。没有一个工作。
最终，我打开了查询，从SQL视图切换到设计视图，然后又回到SQL视图和瞧，看来可以做到这一点。这么奇怪。
本文收集自互联网，转载请注明来源。
如有侵权，请联系[email protected] 删除。
我来说两句