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
|
|||
|
|||
Subtracting Value from Field if Yes/No = Yes
I am in a class learning about Access but I am stuck on this problem and
could use some help. "Change the NetDonation calculated field to subtract the delivery charge of $8.75 from the DonationField value when a pickup is required and to otherwise use the DonationValue field value." I've been stuck on this for an hour now and help would be appreciated, thanks. |
#2
|
|||
|
|||
Subtracting Value from Field if Yes/No = Yes
hi,
On 01.04.2010 06:27, Molarmite wrote: "Change the NetDonation calculated field to subtract the delivery charge of $8.75 from the DonationField value when a pickup is required and to otherwise use the DonationValue field value." I've been stuck on this for an hour now and help would be appreciated, thanks. This means normally using IIf(), e.g. NetDonation: IIf([PickupRequired],[DonationField],[DonationField]-8.75) mfG -- stefan -- |
#3
|
|||
|
|||
Subtracting Value from Field if Yes/No = Yes
A column in your query something like this
NetDonation: IIF([Pickup]=True,[Donation]-8.75,[Donation]) Or NetDonation: IIF([Pickup]="Yes",[Donation]-8.75,[Donation]) "Molarmite" wrote: I am in a class learning about Access but I am stuck on this problem and could use some help. "Change the NetDonation calculated field to subtract the delivery charge of $8.75 from the DonationField value when a pickup is required and to otherwise use the DonationValue field value." I've been stuck on this for an hour now and help would be appreciated, thanks. |
#4
|
|||
|
|||
Subtracting Value from Field if Yes/No = Yes
Other way round
NetDonation: IIf([PickupRequired],[DonationField]-8.75,[DonationField]) "Stefan Hoffmann" wrote: hi, On 01.04.2010 06:27, Molarmite wrote: "Change the NetDonation calculated field to subtract the delivery charge of $8.75 from the DonationField value when a pickup is required and to otherwise use the DonationValue field value." I've been stuck on this for an hour now and help would be appreciated, thanks. This means normally using IIf(), e.g. NetDonation: IIf([PickupRequired],[DonationField],[DonationField]-8.75) mfG -- stefan -- . |
#5
|
|||
|
|||
Subtracting Value from Field if Yes/No = Yes
ho Ronaldo,
On 01.04.2010 11:57, RonaldoOneNil wrote: Other way round Correct, but sometimes there must be something left to be puzzled out by the OP...) mfG -- stefan -- |
#6
|
|||
|
|||
Subtracting Value from Field if Yes/No = Yes
Silly question but I have often wondered about this - What is an OP?
Thanks Kevin "Stefan Hoffmann" wrote in message ... ho Ronaldo, On 01.04.2010 11:57, RonaldoOneNil wrote: Other way round Correct, but sometimes there must be something left to be puzzled out by the OP...) mfG -- stefan -- |
#7
|
|||
|
|||
Subtracting Value from Field if Yes/No = Yes
hi,
On 01.04.2010 15:44, kc-mass wrote: Silly question but I have often wondered about this - What is an OP? Questions are never silly... OP stands for Original Post or Original Poster depending on the context. mfG -- stefan -- |
Thread Tools | |
Display Modes | |
|
|