问题构建ACCESS查询以回溯记录。 [英] Problem building ACCESS query for retrival of records.

问题描述

我想在微软ACCESS的查询中写出这样的标准，它可以给出带有第二个日期的记录吗？

table&字段............所需的输出

no-name-date .............. name-date

1-A-07/15/07 .............. A-07/15/07

2-A-08 / 18/07 ............... B-04/12/07

3-B-04/12/07

4-B- 08/18/07

5-A-07/03/07

I want to write such criteria in the query of microsoft ACCESS, which can give records with secondlast date?
table & fields............desired output
no-name-date..............name-date
1-A-07/15/07..............A-07/15/07
2-A-08/18/07..............B-04/12/07
3-B-04/12/07
4-B-08/18/07
5-A-07/03/07

推荐答案

我想在微软ACCESS的查询中写出这样的标准，它可以给出带有第二个日期的记录吗？

table&字段............所需的输出

no-name-date .............. name-date

1-A-07/15/07 .............. A-07/15/07

2-A-08 / 18/07 ............... B-04/12/07

3-B-04/12/07

4-B- 08/18/07

5-A-07/03/07

I want to write such criteria in the query of microsoft ACCESS, which can give records with secondlast date?
table & fields............desired output
no-name-date..............name-date
1-A-07/15/07..............A-07/15/07
2-A-08/18/07..............B-04/12/07
3-B-04/12/07
4-B-08/18/07
5-A-07/03/07

我不认为你要求的是什么使用传统的SQL，但我认为它可以在代码中完成。还有其他主持人/专家比我更熟练的SQL，所以我只是等着看他们的想法。同时，以下SQL将显示每个名称的Last Date。我知道这不是解决方案，但它是一个起点：

I don''t think that what you are requesting can be done with traditional SQL, but I think it can be done in code. There are other Moderators/Experts more proficient in SQL than I, so I''m just going to wait and see what they think. In the mean time, the following SQL will display the Last Date for each name. I know that it is not the solution, but it is a starting point:

展开 | 选择 | Wrap | 行号

感谢您重定向我的路，可能我可以接近解决方案

Thanks for redirecting me towards the way, probably i can go near the solution

感谢您重新定向我的方式，可能我可以接近解决方案

Thanks for redirecting me towards the way, probably i can go near the solution

非常欢迎你。我会继续监视这篇文章，如果找不到可行的解决方案，我会尝试通过代码。

You''re quite welcome. I''ll continue to monitor this Post, and if no viable solution is found, I''ll attempt one through code.

这篇关于问题构建ACCESS查询以回溯记录。的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！