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

comparing strings

Status
Not open for further replies.
espltd

espltd

Programmer
Apr 6, 2005
233
US
Hi, I have a report using Crystal 10 that comes with vs2005 and in the details section I have a formula. In the detail section the records look like with formula1 =length+width
but I want formula 1 to display 0 if the Name starts with ss. Just wondering if there is a way to do this in the formula,
if Name not like "ss*"
length+width

Name formula1 length width
sstruck 0 20 10
car 100 50 100
Thanks Paul.
 
Sort by date Sort by votes
Got it working, just used like "ss*
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

nerdygirlgear
  • Locked
  • Question
Formula evaluating a list of 50 values that are strings.
Replies
1
Views
187
1tufgt
1tufgt
0sprey
  • Locked
  • Question
Comparing three (3) Tables in a MS Access database with CR11 Report
Replies
1
Views
190
Charliy
Charliy
ginaburg
  • Locked
  • Question
Comparing dates by using other criteria
Replies
8
Views
187
ginaburg
ginaburg
bdmoran
  • Locked
  • Question
Comparing Weeks By year
Replies
13
Views
333
bdmoran
bdmoran
rwaegener
  • Locked
  • Question
excel database number fields being brought into crystal as strings
Replies
1
Views
89
IanWaterman
IanWaterman

Part and Inventory Search

Sponsor

Back
Top