Dates & Values

[Guest]

Hi, I have two questions which are causing me some serious head scratching!

Firstly, I have a form that links to a subform, works well, but I was asked
a question and cannot think of a possible solution. Once all the records
have been input, there will be approx. 1,200.

Each year, the team have to mail out a letter to each of the contract
holders (which I can merge into word quite easily), my question is, when the
letters have been generated, each record needs to be updated with a date for
when the letter was mailed. To do this 1,200 times would take a little
while. Is there a quick way around this?

Secondly, on another form with another subform, if a customer requests a
repair, the user can select the repair and the rate automatically appears, as
it is set in a table. These rates however increase every year and I was
hoping to somehow increase the rates in the table, but for any previous
repairs it would keep the rate that was applied at that time.

I did think about setting the rates up with a year field, but was put off
with number of repairs that we have to do.

Again any solution or advice would be very appreciated.

 

[JK]

Hi, I have two questions which are causing me some serious head
scratching!

Firstly, I have a form that links to a subform, works well, but I was
asked
a question and cannot think of a possible solution. Once all the records
have been input, there will be approx. 1,200.

Each year, the team have to mail out a letter to each of the contract
holders (which I can merge into word quite easily), my question is, when
the
letters have been generated, each record needs to be updated with a date
for
when the letter was mailed. To do this 1,200 times would take a little
while. Is there a quick way around this?

Run an Update query to update the date when the letter are sent

Secondly, on another form with another subform, if a customer requests a
repair, the user can select the repair and the rate automatically appears,
as
it is set in a table. These rates however increase every year and I was
hoping to somehow increase the rates in the table, but for any previous
repairs it would keep the rate that was applied at that time.

I did think about setting the rates up with a year field, but was put off
with number of repairs that we have to do.

In the repairs table craete a field for the rate and copy the rate into it
at the time when a repair is orderd. In this way the new rate wil apply only
to repairs ordered after the rate was updated

Again any solution or advice would be very appreciated.

Regards/JK

 

[Guest]

A. " Run an Update query to update the date when the letter are sent"
Q. Sorry JK, due to my lack of experience writing posts, I missed out some
key info, I tried the update query, which worked, but I need to keep the
previous years letter info as history, plus it didn't update records that
have no previous information in them. The info you provided me with so far
though has given me another tip for future databases.

A. "In the repairs table create a field for the rate and copy the rate into
it at the time when a repair is orderd. In this way the new rate wil apply
only to repairs ordered after the rate was updated."
Q. How would I do this?, my current field is called 'charge' and how would I
get it to keep the info without it updating when the charges go up each year?

thank you for the quick response.

 

[JK]

Hi Re Man

A. " Run an Update query to update the date when the letter are sent"
Q. Sorry JK, due to my lack of experience writing posts, I missed out some
key info, I tried the update query, which worked, but I need to keep the
previous years letter info as history, plus it didn't update records that
have no previous information in them. The info you provided me with so
far
though has given me another tip for future databases.

Sound like you you need another table for the dates, with a a one-to-many
realation to the customers.

A. "In the repairs table create a field for the rate and copy the rate
into
it at the time when a repair is orderd. In this way the new rate wil apply
only to repairs ordered after the rate was updated."
Q. How would I do this?, my current field is called 'charge' and how would
I
get it to keep the info without it updating when the charges go up each
year?

I presume that have a table with the charges,someting like:

Tbl Charges
-------------
Charge_ID
ChargeName
Charge
etc.

The also another table for the orders of repairs such as:

TblOrder
Order_ID
Charge_ID
OrderDate
etc.

And if you dont, you should have one-to-many realshions on Charge_ID

Though the decription of your problem, you don't keep the charge in the
second table and you totally rely on the charges table for actual rate.

If my assumptions are correct, my suggestion was to add, a field Chargeto
the scond table and its form and when a reapair is orderd put the rate (you
already have it - yousaid that is displayed) in the second table.

I hope that this make sense, if not I suggest that you post your table/Forms
structures (only the relevant parts) which would help to help.


Regards/JK