If-then statement in query

[Brian Jorgenson]

Is it possible to add a If-then statement in a query? For example, If
field B is greater then field A, then field B = something else.

I am creating a class schedule. My class size's are 5 people max. If 5
people or more sign up for this class, I wan't a field to show the
word FULL so nobody signs up for this class since it is full. Field A
shows the maximum number of people who can attend this class. Field B
shows the number who have allready signed up. When field B reaches the
5, I want field B to show the word FULL.

Hope somebody can help.

THanks,
Brian

[Bas Cost Budde]

Brian Jorgenson wrote:

Is it possible to add a If-then statement in a query? For example, If
field B is greater then field A, then field B = something else.

I am creating a class schedule. My class size's are 5 people max. If 5
people or more sign up for this class, I wan't a field to show the
word FULL so nobody signs up for this class since it is full. Field A
shows the maximum number of people who can attend this class. Field B
shows the number who have allready signed up. When field B reaches the
5, I want field B to show the word FULL.

Have iif(fieldB>=5,"FULL",fieldB) as expression in the query designer.
You must label this something different from fieldB (because that would
cause a circular reference).

--
Bas Cost Budde
http://www.heuveltop.org/BasCB
but the domain is nl