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!
-
Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Can't get my query to return the number ZERO in my text field count
- Thread starter chubby
- Start date
tlbroadbent
MIS
I'm unclear what you mean. If you are counting the records and want the result returned as text instaed of number use
the CStr function.
Select Cstr(Count(*)) As Cnt From table
If you only want it to be text when zero and numeric otherwise. Add the IIF Function.
Select IIf(Count(*)=0,"0",Count(*)) As Cnt From table
Let me know if these samples help you get closer to meeting your requirement. Terry
"I shall try to correct errors when shown to be errors, and I shall adopt new views so fast as they shall appear to be true views." - Abraham Lincoln
the CStr function.
Select Cstr(Count(*)) As Cnt From table
If you only want it to be text when zero and numeric otherwise. Add the IIF Function.
Select IIf(Count(*)=0,"0",Count(*)) As Cnt From table
Let me know if these samples help you get closer to meeting your requirement. Terry
"I shall try to correct errors when shown to be errors, and I shall adopt new views so fast as they shall appear to be true views." - Abraham Lincoln
- Status
Similar threads
- Locked
- Question
- Question