Yes, you just add a second hidden control to the parent form that is bound to the GroupID on the Groups subform; then use that as the master field in...
So power BI or whatever else you might be using is not capable of getting one value from each of 2 tables and subtracting them? If not, then as long...
Using only an unbound control on a form, you would have to use vba to store the value, or run an update query (e.g. with a button click) that can get...
You didn't gave any info about your table structures (what would be essential to get better responses) in your post, so I can only guess here, but I...
Well, the value needs to be saved, so if it's not calculated I would just do the subtraction in my head and type in the number. But I understand what...