iif functions

S

Struggling Student

Hi, I am a student learning about Access and we are going through IIf
functions right now. I am having a hard time trying to decipher the proper
way to interpret the expression. For instance, Assuming all the tables are
available, and you are asked to run a query with a calculated field... How do
you interpret this in the field:
"Add a calculated field named Trip Fee that multiples the Fee/Person and
People Fields;use the IIf function to reduce the Trip Fee by 10% if the
People field value is greater than six."

Am I to insert 2 fields, one for the Trip Fee, and one for the Trip fee with
a discount?
 
D

Dirk Goldgar

"Struggling Student" <Struggling [email protected]>
wrote in message
Hi, I am a student learning about Access and we are going through IIf
functions right now. I am having a hard time trying to decipher the
proper way to interpret the expression. For instance, Assuming all
the tables are available, and you are asked to run a query with a
calculated field... How do you interpret this in the field:
"Add a calculated field named Trip Fee that multiples the Fee/Person
and People Fields;use the IIf function to reduce the Trip Fee by 10%
if the People field value is greater than six."

Am I to insert 2 fields, one for the Trip Fee, and one for the Trip
fee with a discount?
Click to expand...

It seems pretty clear to me that you are to add a single calculated
field named "Trip Fee". That field should make use of the IIf function
to apply a 10% discount to the fee that would normally be calculated, in
the case where the value of the People field is greater than six.
 
D

Dirk Goldgar

"Struggling Student" <[email protected]>
wrote in message
I have tried several experssions for "Add a calculated field named
Trip Fee that multiples the Fee/Person, and People Fields;use the IIf
function to reduce the Trip Fee by 10% if the People field value is
greater than six." and i still get an error, could someone please
show me how this IIf expression looks like in the calculated field.
Thanks a bunch.
Click to expand...

Show us what you've tried, and maybe we can point out what's wrong.
 
Top