I have 2 linked tables "clients" and "interactions" Each table collects various information about clients.
The interactions table includes a combo field to show whether they get jobs or some other outcome. If they get a job itis marked "GE". I wish to collate a report that shows "GEs" (gained employments) for each client. However I want the report to also show the non-"GE" outcomes for each GE client. It is tricky because there will be clients who dont get "GE"s.
Do I need some for of VB or SQL solution? IF statement :confused: ?