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

making count a boolean 1

Status
Not open for further replies.
jmodo

jmodo

Programmer
Joined
Aug 2, 2006
Messages
43
Location
US
(Select Count(*) from [A] where idA = [A].idA and [A].idB=.idB)

I would like this to return true/false, instead of a number. All I can figure out is how to format it.

Thanks,
J
 
Sort by date Sort by votes
Use the CBool function.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

C
  • Locked
  • Question Question
Query expression negative to a 0
Replies
6
Views
728
dhookom
dhookom
serino
  • Locked
  • Question Question
Help with a Query.
Replies
13
Views
1K
strongm
strongm
Swi
  • Locked
  • Question Question
Select X of each variation of a field
Replies
8
Views
850
rashmibala
R
TheresAlwaysAWay
  • Question Question
Why does what appears to be a simple append query is pasting 5 duplicate rows?
Replies
9
Views
221
TheresAlwaysAWay
TheresAlwaysAWay
BugZap13
  • Locked
  • Question Question
Need help creating a date from two fields to be used in where clause
Replies
5
Views
854
mikrom
mikrom

Part and Inventory Search

Sponsor

Back
Top