在多值字段中使用DSum [英] use DSum in multi-value field

问题描述

大家好，


我是新来的，也是Access2007的新手！


我在表单中有一个多值字段，并希望计算此字段中所选值的总和，并将总计放在文本框中。


我所知道应该使用DSum函数。但我不知道如何使用它甚至在哪里（在文本框或多值字段中）？!!


所以详细的答案将非常感激。


提前谢谢

Hello everyone,

I''m new here and new to Access2007 as well!

I have a multi-value field in a form, and would like to calculate the total of the selected values in this field and place the total in a textbox.

what I know is that should use DSum function. but I have no clue on how to use it or even where (in the textbox or multi-value field)?!!

so a detailed answer would be very appreciated.

thanks in advance

推荐答案

我不知道什么是多值字段是。请解释一下。


您是从一行添加多个字段来插入该行的文本框中的值吗？或者您是在多行中从一列添加值以获得底线总数？


Jim

I don''t know what a "multi-value field" is. Please explain.

Are you adding multiple fields from one row to plug a value in a text box for that row? Or are you adding values from one column on multiple rows to get a bottom line total?

Jim

多值字段是一个查阅列允许您选择多个值并将它们存储在一个字段中。我从这里了解到它： http://office.microsoft.com/en-us/ac...001233722.aspx


我想要做的是从中添加值多行上的相同列，并在文本框中显示总计。显然我想只添加选中的行。


关于如何做到这一点的任何想法？


问候，

multi-value field is a lookup column that allow you to select more than one value and store them in one field. I learnt about it from here: http://office.microsoft.com/en-us/ac...001233722.aspx

what I want to do is adding values from the same column on multiple rows and show the total in the textbox. obviously I want to add only the rows that are selected.

any idea on how to do this?

regards,

Access 2007中允许的多值字段是为特定目的而设计的。它不是用来计算值的东西，而应该只在非常有限的情况下使用。实际上它只是一种列表框形式，专为与sharepoint服务一起使用而设计，以利用它们的一些功能。


但是，如果你想预先形成任何在这个列表上的行动其他存储它你不能。它不是故意的。

The multivalue field allowed for in Access 2007 is designed for a specific purpose. It''s not intended as something you use to calculate values on and should only ever be used in very limited circumstances. In reality it''s just a form of listbox and has been designed specifically for use with sharepoint services to take advantage of some of their features.

However, if you want to preform any action on this list other that store it you can''t. It''s just not meant for that.

这篇关于在多值字段中使用DSum的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！