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

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
--

Hello Terry.

"Terry Hollands" wrote
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

--
ICT Tutor


"Wolfgang Kais" wrote:

Hello Terry.

"Terry Hollands" wrote
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

Hell Terry.

Terry Hollands wrote:
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)

--
Regards,
Wolfgang