M
Malcolm Potter
Hi all
One of the queries within my database contains seven fields, all derived
from one table. I would like to add an eighth field to this query which
returns one of three strings ("Above", "Equal To" or "Below") dependant upon
the values of the numbers appearing in two of the other fields. Will I need
to construct a 'Function' to do this, using something like an
'If...Then...Else' routine and, if so, how do I call up this function within
the query?
I am using Access 2002.
Regards
Malcolm
One of the queries within my database contains seven fields, all derived
from one table. I would like to add an eighth field to this query which
returns one of three strings ("Above", "Equal To" or "Below") dependant upon
the values of the numbers appearing in two of the other fields. Will I need
to construct a 'Function' to do this, using something like an
'If...Then...Else' routine and, if so, how do I call up this function within
the query?
I am using Access 2002.
Regards
Malcolm