4
4charity
Trying to figure out the best way to do this.
I have client records that are compiled into monthly reports, which show how
much housing assistance was given per client. The report lists basic client
info, landlord, $amount dispersed, #bedrooms, and then an adjustment amount
and memo (these 2 are only occassionally used.)
I have created a form/subform.
Form: Basic Client Info/Landlord
Subform: Autodate (NOW), Amount, Bedrooms, Adjustment, Memo.
Most of the information stays the same from month to month, unless a yearly
lease is renewed, and the Amount or Bedrooms change. The adjustment would be
added once in awhile, if an extra bill was paid.
I thought I would have the subform autogenerate the same data each month,
and then have all of the data in an Append Table Query, so that a record
would be kept of what was actually paid each month. But can I get Access to
automatically generate a new record, copying all of the old data (except for
the new autodate) in the subform? I have no clue on how to do this, it just
seemed like one way to skin a cat.
If anyone has the solution on how to do this, it would be much appreciated.
Or, a bettter way of doing it.
There are 3 tables involved - Clients, Landlord, Payment.
Right - sometimes the landlord changes midstream, too.
Thx.
I have client records that are compiled into monthly reports, which show how
much housing assistance was given per client. The report lists basic client
info, landlord, $amount dispersed, #bedrooms, and then an adjustment amount
and memo (these 2 are only occassionally used.)
I have created a form/subform.
Form: Basic Client Info/Landlord
Subform: Autodate (NOW), Amount, Bedrooms, Adjustment, Memo.
Most of the information stays the same from month to month, unless a yearly
lease is renewed, and the Amount or Bedrooms change. The adjustment would be
added once in awhile, if an extra bill was paid.
I thought I would have the subform autogenerate the same data each month,
and then have all of the data in an Append Table Query, so that a record
would be kept of what was actually paid each month. But can I get Access to
automatically generate a new record, copying all of the old data (except for
the new autodate) in the subform? I have no clue on how to do this, it just
seemed like one way to skin a cat.
If anyone has the solution on how to do this, it would be much appreciated.
Or, a bettter way of doing it.
There are 3 tables involved - Clients, Landlord, Payment.
Right - sometimes the landlord changes midstream, too.
Thx.