Filtering and summing a calculated field on a subform

pkfloyd

pkfloyd

Joined
Apr 27, 2015
Messages
1
Reaction score
0
I have a sub form showing products that are sold and ones that are picked up as a credit. I am using a yes\no check box to select which items should be credited. Both are in a calculated field called LineTotal. Is there a way to filter this field by using the yes\no check box so that each will have its own subtotal in the sub form footer?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Running Sum on a Continuous View subform 1
MS Access 2007: Calculated field based on subform: 1
calulated field on main after filtering subform 3
Using a Combo Box for Filtering a Continous Form 2
Calculated Field in a Pivottable 3
Calculated Field in a Pivottable 2
filtering a form based on the values of a subform 0
Summing a calculated field 1

Top