F
Frank Situmorang
Hello,
For statistical purposes, we need to know how many couple do we have with
marriage age 0 to 5 Years...etc..
I have family table PM linked with member table ( with family ID is FK), so
the query will show as follows
Name of Household Name Date of marriage
( family table) ( membertable) (Member table )
========== ========== ===========
1. Household A Mr White 14 Feb 1995
1. Household A Mr. While 14 Feb 1995
2. Household B Mr. Black 22 Oct 2000
2. Household B Mrs Black 22 Oct 2000
I have to admit that maybe there is a weakness of the database structure
because there a repition of the date/data. But I do not want to reset it back.
So my question is what formula should I make in order to know how many
household with marriage age 5 years and then with 10 years.
There is formula using Date Different from NOw to date of marriage, but how
can we make it to count 2 records in the same household and the same date of
marriage will count AS ONE
Thanks for any help
For statistical purposes, we need to know how many couple do we have with
marriage age 0 to 5 Years...etc..
I have family table PM linked with member table ( with family ID is FK), so
the query will show as follows
Name of Household Name Date of marriage
( family table) ( membertable) (Member table )
========== ========== ===========
1. Household A Mr White 14 Feb 1995
1. Household A Mr. While 14 Feb 1995
2. Household B Mr. Black 22 Oct 2000
2. Household B Mrs Black 22 Oct 2000
I have to admit that maybe there is a weakness of the database structure
because there a repition of the date/data. But I do not want to reset it back.
So my question is what formula should I make in order to know how many
household with marriage age 5 years and then with 10 years.
There is formula using Date Different from NOw to date of marriage, but how
can we make it to count 2 records in the same household and the same date of
marriage will count AS ONE
Thanks for any help