RE: [MS_AccessPros] How to total up a column

 

I really wouldn't recommend code when simple expressions will work. However you could open a recordset and use the values to populate unbound text boxes.
 
Duane Hookom MVP
MS Access
 

---

From: saigonf7q5@yahoo.com

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 (7)

Visit Your Group

• Privacy • Unsubscribe • Terms of Use

.

__,_._,___