Recent content by Fourstar

Thanks for the quick reply! I tried that, and it almost worked except that the other 5 queries in the report are cross-tab queries related by month so I ended up with no relational link for this query and I had 144 rows. I may have to redesign the entire thing, which I am trying to avoid.:o

I have a complicated report that uses 6 crosstab queries to build a master query that feeds a report. The report tracks data by month during a specific year. One of the sub-queries counts the number of permit applications and displays them by month (row) and year (column). (The fields...