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

  • Thread starter Thread starter Terry Hollands
  • Start date Start date
T

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
--
 
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?
Click to expand...

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


Wolfgang Kais said:
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?
Click to expand...

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?
Click to expand...
Terry
 
Hell Terry.

Terry said:
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?
Click to expand...
Enter REBATE: [Fee Paid]*0.15 in the field section, no criteria.
Click to expand...
Click to expand...
Thanks for that Wolfgang.
Can I then make the field a currency field and if so How?
Click to expand...

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

REBATE: CCur([Fee Paid]*0.15)
 
Back
Top