在“默认值”中构建表达式以返回多个字段的最大值 [英] Building an expression in Default Value to return max value for multiple fields
问题描述
我在表格中有字段，包括会议日期，电话，邮件以及与客户的其他联系。我有一个字段是最近的联系日期。我希望该默认值是所有类型的联系人中最近的日期。如何在表的默认值区域中构建此表达式？我基本上需要能够在5个领域中返回最近日期的东西。谢谢！
I have fields in a table that include dates of meetings, phone calls, mailings, and other contact with clients. I have one field that is "most recent contact date". I want that default value to be the most recent date among all the types of contacts. How would I build this expression in the default value area of the table? I basically need something that will return the most recent date among 5 fields. Thanks!
推荐答案
我在表格中有字段，包括会议日期，电话，邮件和其他内容与客户联系。我有一个字段是最近的联系日期。我希望该默认值是所有类型的联系人中最近的日期。如何在表的默认值区域中构建此表达式？我基本上需要能够在5个领域中返回最近日期的东西。谢谢！
I have fields in a table that include dates of meetings, phone calls, mailings, and other contact with clients. I have one field that is "most recent contact date". I want that default value to be the most recent date among all the types of contacts. How would I build this expression in the default value area of the table? I basically need something that will return the most recent date among 5 fields. Thanks!
将其放入代码模块中。请注意您使用它的方式是在注释＃1中
Drop this into a code module. Notice the way you use it is in comment # 1
我是新手访问用户，所以我完全不明白如何使用你给我的信息。我可以将一些代码剪切并粘贴到默认值中吗？在我的表格设计中，例如：
= MaxFromList（[第一次通话]，[第二次通话]，[邮寄]，[会议日期]，[谢谢]，[关注]打电话]）
我知道这不对，因为我收到了一条错误信息。但我认为我需要这些内容。
你是说我必须先运行一个查询才能得到我想要的默认值最近的联系日期。字段？
再次感谢！
I am a novice Access user, so I couldn''t understand entirely how to use the information you gave me. Can I cut and paste some code into the "Default Value" line in my table design, such as:
=MaxFromList([first call],[second call],[mailing],[meeting date],[thank you],[follow up call])
I know this isn''t right, because I get an error message from it. But I think I need something along these lines.
Are you saying I have to run a query first to get the default value I want for my "most recent contact date" field?
Thanks again!
我是新手访问用户，所以我不能完全不了解如何使用你给我的信息。我可以将一些代码剪切并粘贴到默认值中吗？在我的表格设计中，例如：
= MaxFromList（[第一次通话]，[第二次通话]，[邮寄]，[会议日期]，[谢谢]，[关注]打电话]）
我知道这不对，因为我收到了一条错误信息。但我认为我需要这些内容。
你是说我必须先运行一个查询才能得到我想要的默认值最近的联系日期。现场？
再次感谢！
I am a novice Access user, so I couldn''t understand entirely how to use the information you gave me. Can I cut and paste some code into the "Default Value" line in my table design, such as:
=MaxFromList([first call],[second call],[mailing],[meeting date],[thank you],[follow up call])
I know this isn''t right, because I get an error message from it. But I think I need something along these lines.
Are you saying I have to run a query first to get the default value I want for my "most recent contact date" field?
Thanks again!
我读你的问题的方式，你的表中有一个字段，其中包含日期，你希望在一个单独的字段中有最高日期。如果这不正确，你能为我详细说明吗？
J
the way I read your question, you had moer than one field in your table that had dates in it, and you wanted the highest date in a separate field. If that''s not correct, can you elaborate a little for me?
J
这篇关于在“默认值”中构建表达式以返回多个字段的最大值的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
