If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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 -- |
#2
|
|||
|
|||
How do I add a field to a query and make a calculation?
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 |
#3
|
|||
|
|||
How do I add a field to a query and make a calculation?
-- 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 |
#4
|
|||
|
|||
How do I add a field to a query and make a calculation?
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 |
Thread Tools | |
Display Modes | |
|
|