Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Access - Simple Query - Logical Field...Pls Help !

Status
Not open for further replies.
CSHANKY

CSHANKY

IS-IT--Management
Jun 4, 2003
20
US
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 !

 
Sort by date Sort by votes
Status
Not open for further replies.

Similar threads

JK Dutta
  • Locked
  • Question
requet for form an access query for report
Replies
2
Views
515
dhookom
dhookom
combo
  • Locked
  • Question
'Wrong property setting' message in query 1
Replies
2
Views
528
combo
combo
TheresAlwaysAWay
  • Locked
  • Question
Union query provides different reslt than when summing the combined queries individually 1
Replies
12
Views
395
TheresAlwaysAWay
TheresAlwaysAWay
Moss100
  • Locked
  • Question
Append query dropping leading zero 2
Replies
4
Views
364
Andrzejek
Andrzejek
JimStrand
  • Locked
  • Question
Crosstab query - returning 1 record per week instead of 1 record
Replies
1
Views
280
JimStrand
JimStrand

Part and Inventory Search

Sponsor

Back
Top