Hi, help on this subject is appreci

[gennaro7]

Hi, help on this subject is appreciated. I am creating a crystal report and I want to extract records, in the calldesc field, that have these keywords; voyager, mobility, cash edge. My table is Calllog and the field is calldesc. I am a beginner in SQL programming. What is the (query) code to do this extraction. thanks for the help.

g.

 

[IanWaterman]

Please do not double post.

To link the two tables you need to look at the system data dictionary (if one exists) or speak to the developers to find out which fields relate the two tables together.

Failing that do any reports already exist, you can learn a lot from those reports and may even be able to save as a new report and modify to suit your needs.

Ian

 

[Madawc]

You should also have a meaningful title, rather than "this subject".

And you can select for types using Crystal, though SQL may be more efficient.

Madawc Williams (East Anglia, UK). Using Crystal 2008 with SQL and Windows XP