Need Help

[Dinesh]

Hi,
I was creating a fess collection database for our school. Pupil can pay their fees as "Full Fees" or "Half yearly", or "Quarterly" or by "Monthly". We need the months name automatically generate in Period field.
This will help up to make a Monthly Report.


For example: (Table name:Receipt, Fields:Mode of Payment,Payment Date, Period)

Mode of Payment : Quarterly
Payment Date : 1 March 2015
Period March 2015, April 2015, May 2015).
We need the month names automatically add into the Period field. (if the Mode of Payment is “Half yearly” then Periods will be 6 months names from the Payment date)

Any help will be appreciated.

 

[pbaldy]

What you ask is possible, but probably not a good idea. As a rule, you wouldn't store data like that (multiple values in a single field). Also, what if they paid late and a payment made in April was actually for March-May? I might consider two fields representing the period covered by the payment. I'd look carefully at all the different ways you might want to query that field before deciding on the proper method of storage.

 

[Dinesh]

First of all thanks a lot for responding to my post.
I considered of creating two fields. But I need to print report on Monthly basis, and I don’t know how is it possible!
If I create fields like below:
Mode of Payment : Quarterly
Payment Date : 1 March 2015
PeriodFrom: March 2015
PeriodTo: May 2015
In this case how do I create a monthly report for April Month?
This will definitely solve the late payment issue.
Thanks a lot in advance.
Dinesh

 

[pbaldy]

Well, I would use actual dates for the from and to fields, which should allow you to query for dates within that range.

 

[Wiz47]

First of all thanks a lot for responding to my post.
I considered of creating two fields. But I need to print report on Monthly basis, and I don’t know how is it possible!
If I create fields like below:
Mode of Payment : Quarterly
Payment Date : 1 March 2015
PeriodFrom: March 2015
PeriodTo: May 2015
In this case how do I create a monthly report for April Month?
This will definitely solve the late payment issue.
Thanks a lot in advance.
Dinesh

Where tbl_Main.Date_received Between Forms!frmsearch!txtstart_Date And Forms!frmSearch!txtEnd_Date

Something like this would work. Use your own form and control names. Then you could search the table using a query.