Jumat, 18 April 2014

RE: [MS_AccessPros] How to total up a column

 

Thank you so much Duane

Both the list box and text box methods work pretty good. The text box method is easier to arrange on the form, and easier to make the form looks prettier, while using the list box is quicker and less typing.

 I understand how the list box's row source (SQL code) works, however having trouble to understand the =Sum(Abs(Class="Excel")* [FieldName]) function. Why the "Abs" function is needed, and what the asterisk's role does?

I am interested in learning other options that involve code which you've mentioned.  It would be great if you have that on hand and paste them on the post.

Thanks again Duane and appreciate your help.

Phucon


__._,_.___
Reply via web post Reply to sender Reply to group Start a New Topic Messages in this topic (4)
.

__,_._,___

Tidak ada komentar:

Posting Komentar