从连续表单创建查询 [英] Creating a query from a continuous form

问题描述

您好！


我在尝试根据从连续表单中检索到的数据创建查询时遇到了一些麻烦。它所基于的表格如下：

表= tbl_Appointment

Hello!

I am having a bit of trouble trying to figure out how to create a query based on data retrieved from a continuous form. The table it is based on looks like this:

Table = tbl_Appointment

展开 | 选择 | 换行 | 行号

推荐答案

以下SQL语句将列出给定[App_Per_ID]的最新[App_Date]以及[App_Per_ID]的[App_Outcome_ID]数量：

The following SQL Statement will list the latest [App_Date] for a given [App_Per_ID] as well as the Number of [App_Outcome_ID]s for the [App_Per_ID]:

展开 | 选择 | Wrap | 行号

那个我不是我需要的，对不起，如果我不清楚的话。我只需要显示每个客户的最后一个约会及其结果。从这些结果我将计算最后的结果。虽然在一天中的最佳时刻盯着它，但我认为这是不可能的。


感谢您通过ADezii的努力！

That''s not quite what I need, sorry if I wasn''t clear. I need to display just the last appointment and its outcome for each client only. From these results I was going to do a count of last outcomes. Although after staring at it for the best part of a day, I''m thinking it isn''t possible.

Thanks for your efforts though ADezii!

如果您有兴趣，我很确定我能够找到基于代码的解决方案，请告诉我。

I''m pretty sure that I can arrive at a code-based solution if you are interested, just let me know.

这篇关于从连续表单创建查询的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！