Prev: Can a Table be Updated From a Subquery with Aggregate Count Value?
Next: SubQuery
From: Molarmite on 1 Apr 2010 00:27
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.
From: Stefan Hoffmann on 1 Apr 2010 03:38
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 <--
From: RonaldoOneNil on 1 Apr 2010 04:01
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.
From: RonaldoOneNil on 1 Apr 2010 05:57
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 <--
> .
>
From: Stefan Hoffmann on 1 Apr 2010 06:26
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 <--

 |  Next  |  Last
Pages: 1 2
Prev: Can a Table be Updated From a Subquery with Aggregate Count Value?
Next: SubQuery