Relational Tables plus some

[Guest]

A. I have a pretty flat table that I keep information about families who
recieve a discount at our school. I have made a form to input my information.
On the form, I would like to input the tuition amount and then have the form
calculate 50% of that to be put in the Discount field. So if tution is $360,
the discount is $180. I can get the form to calculate it, but I want it
stored so that I can merge the information into a letter that will go out to
the family.

B. When we give a discount we round that amount that the family pays up to
a whole $. So that if tuition is $345, the family pays $173 and the
discount is $172. I would like the fields to be calulated this way. For the
Family payment, I can just divide tution by 2 and use no decimals. For the
discount field, I thought I could just subract the family payment from
tuition, but it's not working.

Is this too hard for a newbie? Thanks so much for any help.

 

[Tom Lake]

A. I have a pretty flat table that I keep information about families who
recieve a discount at our school. I have made a form to input my
information.
On the form, I would like to input the tuition amount and then have the
form
calculate 50% of that to be put in the Discount field. So if tution is
$360,
the discount is $180. I can get the form to calculate it, but I want it
stored so that I can merge the information into a letter that will go out
to
the family.

NO! You don't want to store it. Create a query with a calculated field in
it if you have to but you don't have to store it.

B. When we give a discount we round that amount that the family pays up
to
a whole $. So that if tuition is $345, the family pays $173 and the
discount is $172. I would like the fields to be calulated this way. For
the
Family payment, I can just divide tution by 2 and use no decimals. For
the
discount field, I thought I could just subract the family payment from
tuition, but it's not working.

Is this too hard for a newbie? Thanks so much for any help.\

[Family Pays] = Int([Tuition] / 2 + .5)
[Discount] = [Tuition] - [Family Pays]

Tom Lake

 

[John Vinson]

I want it
stored so that I can merge the information into a letter that will go out to
the family.

A Mail Merge can - and should - be based on a Query. It is NOT
necessary, nor desirable, nor good design, to store this calculated
field in any Table.


John W. Vinson[MVP]