Subtracting Value from Field if Yes/No = Yes

[Molarmite]

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.

 

[Stefan Hoffmann]

hi,

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

 

[RonaldoOneNil]

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

 

[Stefan Hoffmann]

ho Ronaldo,

Other way round

Correct, but sometimes there must be something left to be puzzled out by
the OP...)


mfG
--> stefan <--

 

[kc-mass]

Silly question but I have often wondered about this - What is an OP?

Thanks

Kevin

 

[Stefan Hoffmann]

hi,

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