I created a form with 7 fields (each day of the week) and want the total miles for the week. I used =sum([Miles1]+[Miles2]+[Miles3]+[Miles4]+[Miles5]+[Miles6]+[Miles7]). Error: The expression On Click you entered as the event property setting produced the following error: The function you entered can't be used in this expression. What is the correct way of doing this?
If you are a Visitor, go ahead and post your reply as a
new comment, and we'll move it here for you
once it's approved. Be sure to use the same name and email address.
This thread is now CLOSED. If you wish to comment, start a NEW discussion in
Access Expert 8.
