Searching Table

[plog]

You can use the same main/subt method you did for forms. Main report based of the user, sub-report based off qualifications.


Or you could use your query that you have now as the basis for that report and then use Grouping. Group all the user level data into a section and then in the detail section just show the qualification.

 

[Robster]

Thanks again Plog.
Have now normalised the entire database and it's working well.