Hi
I am new to Access in programming but had been use it for some simple appication on my office work.
Recently I have accounter a problems on the "date" & really need someone to help urgently.
I am writting a simple DB for an insurence agency for him to manage his work. One of the request is to have his report special customise.
I have a table of all policy holder which include name, policy number, [date]- Policy Purchase date (or due date) & [Mode] - mode of payment. There are 4 catogories of [Mode] e.g Q=quater pyment - 4 times a year, S= semi payment - twice a year, M= Monthly payment & A = annual - once a year.
Question A:
The requre report have the field of [name], [Plicy No], [Mode], [1],[2],[3],[4],......[12] which indicate the month of different payment. finally [Yr] for the year of purchase.
We need :
(1) When the due date, the "day" (2 digit) need to appear under the field of related [Month]
(2)If the [Mode] is Q, there will be 3 more marking as "X" under the realted month..."m"+3, "m"+6, "m"+9.
(3) If the [Mode] is S, there will be one more "X" under the related month ..."m'+6
(4)If the [Mode] is A or M, no additional marking of "X" is require.
(5) On the month of [3],[6], [9], when ther is no indicate of the purchase day & marking "X", have a mark string "."
Question B
I wish in a sub-query where when the [Mode] is Q, there will be additional 4 rows appeare automatically which indicate the different date.
Please help to clear this as I already spend too much on the above problems.
Thanks a lot.
jiajian
I am new to Access in programming but had been use it for some simple appication on my office work.
Recently I have accounter a problems on the "date" & really need someone to help urgently.
I am writting a simple DB for an insurence agency for him to manage his work. One of the request is to have his report special customise.
I have a table of all policy holder which include name, policy number, [date]- Policy Purchase date (or due date) & [Mode] - mode of payment. There are 4 catogories of [Mode] e.g Q=quater pyment - 4 times a year, S= semi payment - twice a year, M= Monthly payment & A = annual - once a year.
Question A:
The requre report have the field of [name], [Plicy No], [Mode], [1],[2],[3],[4],......[12] which indicate the month of different payment. finally [Yr] for the year of purchase.
We need :
(1) When the due date, the "day" (2 digit) need to appear under the field of related [Month]
(2)If the [Mode] is Q, there will be 3 more marking as "X" under the realted month..."m"+3, "m"+6, "m"+9.
(3) If the [Mode] is S, there will be one more "X" under the related month ..."m'+6
(4)If the [Mode] is A or M, no additional marking of "X" is require.
(5) On the month of [3],[6], [9], when ther is no indicate of the purchase day & marking "X", have a mark string "."
Question B
I wish in a sub-query where when the [Mode] is Q, there will be additional 4 rows appeare automatically which indicate the different date.
Please help to clear this as I already spend too much on the above problems.
Thanks a lot.
jiajian
