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!

Need a formula to pull the record contain with the value in the field

Status
Not open for further replies.
huichun

huichun

Programmer
Jul 24, 2002
8
US
I am trying to use following record selection formula to pull record contain with value (G) in the field but with no success, please help.

'G' in {recap.batchnmber}[3] ** any batches contains G in position 3

Huichun

 
Sort by date Sort by votes
I don't see why that wouldn't work. Is it throwing an exception or just not returning any records?
 
Upvote 0 Downvote
ok, that worked. Now I need record without "G" in 3rd position. Any thoughts?

 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

smmt2207
  • Locked
  • Question
Text field formula help
Replies
1
Views
157
hilfy
hilfy
JustMe24
  • Locked
  • Question
How to select from 2 rows in a table
Replies
1
Views
156
SoftwareRT
SoftwareRT
David Richardson
  • Locked
  • Question
Adding BLOB Fields to Reports in Crystal Reports Professional 8.5
Replies
7
Views
270
hilfy
hilfy
D
  • Question
Stored Procedure with no Parameters
Replies
1
Views
238
hilfy
hilfy
K
  • Locked
  • Question
We're using command in crystal report
Replies
1
Views
220
hilfy
hilfy

Part and Inventory Search

Sponsor

Back
Top