Issue with turning crosstab into form (1 Viewer)

HI All,

I have a crosstab query that runs in about 9 seconds.. pretty good i would think.

My issue though is everytime I try to turn it into a form, access stops responding. I tried specifying an ID to narrow down the query and now I cant even save the query...

Does anyone have any tips on this?

Solved this issue by doing a make table on the crosstab query. Works like butter now.