472,114 Members | 1,162 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 472,114 software developers and data experts.

the sum formula form query and in form does not work properly of w

1 Bit
I have to calculate the Total No.of Family members in the query, it calculate correctly. but when i applied on the form it does not work. e.g if want to calculate the total number of family members in the form like that if martial status in single then only "Self" be active and other like wife, children above and below 12 would be disabled. when I select "single" from martial status the "Self" field is active and other become disable. it works correctly but when i enter "1" in the self field the total of number family members not correctly calculated and sum equal to "0" which must be equal to "1". When i select "Marrried" from dropdown list all the family information active and it enters the numbers and it show the sum correctly but in case of "self" it does not give the sum correctly. what i use in the query or form to obtain the correct sum. please help me.
Jan 5 '21 #1
1 1817
409 Expert Mod 256MB
Add a number field FamilyID and give everyone in the same family the same ID value. Group the aggregate query on FamilyID and count on the same field. It won't matter what the marital status is or whether someone is adopted etc
Jan 5 '21 #2

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

1 post views Thread by Dave Patton | last post: by
13 posts views Thread by genetic.error | last post: by
2 posts views Thread by jim | last post: by
reply views Thread by leo001 | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.