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 Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

SELECT QUERY IN IIF STATEMENT

Status
Not open for further replies.
anithamg

anithamg

Programmer
Nov 21, 2002
6
0
0
US
SELECT IIF((SELECT COUNT(*) FROM TBLITINS)>0,1,0)) FROM TBLHOTELS

DOESN'T WORK. CAN I'VE A QUERY IN IIF STATEMENT??

 
Sort by date Sort by votes
This statement, if it worked would either select the field 1 or the field 0 from the table. I doubt seriously that those values correspond to names of fields in your table.

What are you trying to do?

Jeremy =============
Jeremy Wallace
Designing, Developing, and Deploying Access Databases Since 1995

Take a look at the Developer's section of the site for some helpful fundamentals.
 
Upvote 0 Downvote
not only that, it would select the same 0 or 1 for every row in TBLHOTELS!

surely not what you really want, right?


rudy

 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

Swi
  • Locked
  • Question
Jet Sql Statement - Select Distinct Multiple Columns 1
Replies
4
Views
240
Swi
Swi
lameid
  • Locked
  • Question
SELECT FROM Table in Another Access File
Replies
2
Views
299
lameid
lameid
combo
  • Locked
  • Question
'Wrong property setting' message in query 1
Replies
2
Views
292
combo
combo
monkeysee
  • Locked
  • Question
Select Query for append query 1
Replies
12
Views
219
monkeysee
monkeysee
TheresAlwaysAWay
  • Locked
  • Question
Union query provides different reslt than when summing the combined queries individually 1
Replies
12
Views
311
TheresAlwaysAWay
TheresAlwaysAWay

Part and Inventory Search

Sponsor

Back
Top