Sum Field in footer issue - Microsoft Access Forum


	Back to Access Forum Comments List

Upload Images @Reply Bookmark Link Email Next Unseen

Sum Field in footer issue

Mark Pierce

5 years ago

I have a several sum fields in a footer of a subForm and they are all work except one. The one that is not working is summing the total weight of the order from a calculated weight field in each line in the subform.

I cant figure out what I am doing wrong here.

ideas?

	Alex Hedley @Reply 5 years ago
Form Footer Totals Tip

	Alex Hedley @Reply 5 years ago
What isn't working? It doesn't show a value? It shows an error? Do all rows contain a value? If it's calculated have you wrapped it in an NZ and returned 0

	Richard Rost @Reply 5 years ago
Mark, watch that video that Alex pointed you to. Beyond that, without a LOT more information, there's absolutely no way we can help you. Without seeing some screen shots, what your field control sources are, and what your dataset looks like, it's impossible to tell you what's wrong. Please see Rules and Context. Thanks!

	Mark Pierce OP @Reply 5 years ago
Thanks for pointing to the video, that helped me solve it.

This thread is now CLOSED. If you wish to comment, start a NEW discussion in Access Forum.

Next Unseen

New Feature: Comment Live View