Afternoon all!
I currently have 4 queries that show different information depending on the 'Server Name', and what I would like to do is include all of these in 1 subreport; as it would be much more preferable to have 1 report with 1 set of headings, rather than a new set of headings for every single server (it just looks messy!).
I'm aware that the fix for this would be 'grouping' out of the original table, however that isn't an option as I have calculation queries aiding the 4 main ones so it's not something i can pull out of the table.
Is there a way to actually use 4 queries? When I try I get the "you have chosen fields from record sources that the wizard cant connect" error.
Ta in advance