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.

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

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.

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

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

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

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