How do I add a field to a query and make a calculation?

[Terry Hollands]

I have a database with fees paid field and in a query I need to add a 15%
rebate if the student has paid the fee already.
On the query in the criteria line for the fee paid field I have entered the
criteria >0 to select students that have already paid.
If they have paid already they get a 15% discount.
I then tried to create a new field called [REBATE] and entered in the
criteria section [Fee Paid]*0.15 to get the answer but I ma getting nothing
showing.
Any suggestions please?
Terry Hollands
--

 

[Wolfgang Kais]

Hello Terry.

I have a database with fees paid field and in a query I need to add
a 15% rebate if the student has paid the fee already.
On the query in the criteria line for the fee paid field I have
entered the criteria >0 to select students that have already paid.
If they have paid already they get a 15% discount.
I then tried to create a new field called [REBATE] and entered in
the criteria section [Fee Paid]*0.15 to get the answer but I ma
getting nothing showing.
Any suggestions please?

Enter REBATE: [Fee Paid]*0.15 in the field section, no criteria.

 

[Terry Hollands]

--
ICT Tutor

Hello Terry.

I have a database with fees paid field and in a query I need to add
a 15% rebate if the student has paid the fee already.
On the query in the criteria line for the fee paid field I have
entered the criteria >0 to select students that have already paid.
If they have paid already they get a 15% discount.
I then tried to create a new field called [REBATE] and entered in
the criteria section [Fee Paid]*0.15 to get the answer but I ma
getting nothing showing.
Any suggestions please?

Enter REBATE: [Fee Paid]*0.15 in the field section, no criteria.

--
Regards,
Wolfgang


.
Thanks for that Wolfgang. Can I then make the field a currency field and if so How?

Terry

 

[Wolfgang Kais]

Hell Terry.

I have a database with fees paid field and in a query I need to add
a 15% rebate if the student has paid the fee already.
On the query in the criteria line for the fee paid field I have
entered the criteria >0 to select students that have already paid.
If they have paid already they get a 15% discount.
I then tried to create a new field called [REBATE] and entered in
the criteria section [Fee Paid]*0.15 to get the answer but I ma
getting nothing showing.
Any suggestions please?

Enter REBATE: [Fee Paid]*0.15 in the field section, no criteria.

Thanks for that Wolfgang.
Can I then make the field a currency field and if so How?

You could convert the value to currency using the CCur function:

REBATE: CCur([Fee Paid]*0.15)