0

Hi,
I have entered names of student under field NAME in Access, the names are like;-
Mohan Chaturvedi,
Deepa Agarwal,
Mona Agarwal,
Sohan Chaturvehi
etc
With the help of VB6 and Crystal report 8.5 I want to take the Report of those student within whose name the word Agarwal exist. or say the Chaturvedi exist.

In Foxpro 2.6 this type of search is called searching embedded string.

So pl complete the following code

dim a as query
query= Select * from <query name> where <query.Name = .......................

(ehar)

2
Contributors
2
Replies
3
Views
9 Years
Discussion Span
Last Post by kehar
0

query=SELECT * FROM <query name>
WHERE <query.name> like '%textbox1.text%';

use the like condition then concat from where do you want the comparison from.(in this example its textbox1.text.

0

query=SELECT * FROM <query name>
WHERE <query.name> like '%textbox1.text%';

use the like condition then concat from where do you want the comparison from.(in this example its textbox1.text.

Thanks, it work fine. Apart from above pl suggest the technique to shift the long line inserted below a field to seperate each record when the text of a field is wrap up by selecting CAN GROW from format field in Crystal Report.
In short the line is not shifting down when the text grow to multiple line.

(kehar)

This topic has been dead for over six months. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.