Show what's not there! 2

[AyJayEL]

I want to create report that is a letter to a school where they have not sent someone on a course.

I have two tables Schools, Courses. How do I get it to show which schools haven't attended?

I also only want to produce a letter for particular types of schools. Learn something new every day *:->*
AyJayEl

 

[AyJayEL]

Right Ken, I think we are getting somewhere! When I took the Group selection out I got all the schools. So I have kept the count as suggested by you and suppressed the school Group when it the group footer summary is greater than 0 and that seems to work.

Thank you for all your help. I had already given you a star for this but if I could I would give you another! Here is a little music instead. Learn something new every day *:->*
AyJayEl

 

[kenhamady]

The Group selection should do the same thing, but I hate to argue with success. Ken Hamady, On-site Custom Crystal Reports Training & Consulting
Public classes and individual training.
Expert's Guide to Formulas / Guide to Crystal in VB

http://www.kenhamady.com/

- tek@kenhamady.com