访问2013 Custom Web App查询所需的最大功能 [英] Access 2013 Custom Web App Max function needed for query

问题描述

在Query Builder中，Access 2013自定义Web应用程序是否有任何方法可以使用标准的Max（）函数？  我有一个会员期间表，每个会员已为每个会员期支付一个条目。  我想允许员工下载提醒
Mailchimp Excel文件，其中包含会员资格将在未来30天内到期的会员的姓名和电子邮件地址。  通过会员和会员期间表的加入很容易，但我还想检查我是否发送了
续订已经到位的通知。   A  Max（）函数允许我使用子查询或成员期间表的第二次联接对每个成员进行检查。  我可以使用Action宏来做，但我想避免这种情况，只需在查询中执行
。

Is there any way in Query Builder for Access 2013 Custom Web Apps to use a standard Max() function?  I have a Membership Periods table with one entry for each membership period each Member has paid for.  I want to allow staff to download a reminder Mailchimp Excel file containing names and email addresses of Members whose memberships are going to expire in the next 30 days.  That's easy with a join of Members and Membership Periods tables but I also want to check that I'm not sending notices where renewals are already in place.  A Max() function would allow me to make that check for each Member using a subquery or second join of the Membership Periods table.  I can do it with an Action macro but I would like to avoid that and just do it all in a query.

任何见解？  非常感谢！

Any insights?  Thanks very much!

推荐答案

嗨jimbo，

Hi jimbo,

>>在Query Builder中，Access 2013自定义Web应用程序是否有任何方法可以使用标准Max（）函数？

>> Is there any way in Query Builder for Access 2013 Custom Web Apps to use a standard Max() function?

根据我的经验，支持Max函数在Access 2013 Web查询中。您使用它时是否收到任何错误？如果您可以将您的查询设计视图分享给我们，将会很有帮助。

Based on my experience, Max function is supported in Access 2013 web query. Did you get any error when you use it? It would be helpful if you could share us your query design view.

这是一个关于网页查询中Max功能的简单屏幕截图。

Here is a simple screen shot about Max function in web query.

最好的问候，

Best Regards,

Edward

这篇关于访问2013 Custom Web App查询所需的最大功能的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！