Simple Query Design - Logical Field - Help !

[CSHANKY]

Guru's please help this novice....

Ok - so I have this table with 2 fields - Yes/No1 and Text1.

I want a query with both the fields AND a calculated/logical field OUTPUT which should work as follows:

Yes/No1 Text1 OUTPUT
-------- ------ -------
Yes <some text> Complete
No <some text> <some text>

I am not sure how / where to code the SQL statement. :-(

Thanks in advance !

 

[KenReay]

Hi

You can use the query designer to do this, it will guide you through the task

I am not sure of your level of expertise, but the only thing which may not be obvious is to get the word 'complete', in place of the yes/no to do this put:

X:IIF([Yes/No1],&quot;Complete&quot;,&quot;&quot

A further point, for future reference, use a convention for naming your columns, variables etc, it will make life much easier so for example blnComplete rather that Yes/No1, it is meaningful, and it does not contain a special character (/)



Regards

Ken Reay
Freelance Solutions Developer
Boldon Information Systems Ltd
Website needs upgrading, but for now -

http://www.kenneth.reay.btinternet.co.uk

UK