Help With Expression Query

[CS]

I have a simple expression query that I just can not get.
I have a table called discs, in this table there is a logical field (yes,no)
called clubs. I want to be able to use the expression builder so that if the
club value equals yes then the Charge(name of the expression I am trying to
build) will equal 45, if not then equals 65. I am just confusing myself.
Sorry I am new to this and would appreciate any help that anyone could
provide. Thank you and have a great day.

 

[Rick Brandt]

I have a simple expression query that I just can not get.
I have a table called discs, in this table there is a logical field (yes,no)
called clubs. I want to be able to use the expression builder so that if the
club value equals yes then the Charge(name of the expression I am trying to
build) will equal 45, if not then equals 65. I am just confusing myself. Sorry
I am new to this and would appreciate any help that anyone could provide.
Thank you and have a great day.

Charge: IIf([clubs], 45, 65)

The above assumes that you are using a DataType of Yes/No for the clubs field.
Your description does not make that clear. If it is a Text field containing the
words "Yes" and "No", then the expression would need to be...

Charge: IIf([clubs] = "Yes", 45, 65)

 

[David F Cox]

Sorry, I cannot remember when I last used expression builder, but, in QBE
view, using the function IIF :-

ans: IIF([clubs],45,65)
sets a column called answer to 45 or 65.

IIF( test, result if true, result if false)

 

[CS]

Thank you very much Rick, your help was greatly appreciated. Once again
thank you.

I have a simple expression query that I just can not get.
I have a table called discs, in this table there is a logical field
(yes,no) called clubs. I want to be able to use the expression builder so
that if the club value equals yes then the Charge(name of the expression
I am trying to build) will equal 45, if not then equals 65. I am just
confusing myself. Sorry I am new to this and would appreciate any help
that anyone could provide. Thank you and have a great day.

Charge: IIf([clubs], 45, 65)

The above assumes that you are using a DataType of Yes/No for the clubs
field. Your description does not make that clear. If it is a Text field
containing the words "Yes" and "No", then the expression would need to
be...

Charge: IIf([clubs] = "Yes", 45, 65)