Is there an easy way to create a matrix? I was thinking of a crosstab query, and it seems to fit, but some things I would want to change. This is the layout I am looking to develop, but I wanted to know if it is really possible. Down the left side would be training requirements, across the top would be employees, the results would show which employee is trained on a particular task marked with an X in the result area. Right now I can get training and employees, but the results show dates that an employee was trained on a particular task. Is there a way to replace the date with just an X to mark that they are trained. Just looking for opinions if this is possible.
Thanks,
Dave
Thanks,
Dave