Subtracting Value from Field if Yes/No = Yes

  • Thread starter Thread starter Molarmite
  • Start date Start date
M

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.
 
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.
Click to expand...
This means normally using IIf(), e.g.

NetDonation: IIf([PickupRequired],[DonationField],[DonationField]-8.75)


mfG
--> stefan <--
 
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])
 
hi,

Silly question but I have often wondered about this - What is an OP?
Click to expand...
Questions are never silly...

OP stands for Original Post or Original Poster depending on the context.


mfG
--> stefan <--
 
Back
Top