N NebraskaUser Registered User. Local time Today, 15:51 Joined Aug 17, 2018 Messages 12 Sep 24, 2018 #1 Ideally, I need to display four different cross-tab queries on the same report or form. Any idea how I might do that?
Ideally, I need to display four different cross-tab queries on the same report or form. Any idea how I might do that?
Minty AWF VIP Local time Today, 23:51 Joined Jul 26, 2013 Messages 10,666 Sep 24, 2018 #2 If they have a suitable field you could join them in another query ? Alternatively look at putting each one into its own sub report, and then put each subreport into a master report.
If they have a suitable field you could join them in another query ? Alternatively look at putting each one into its own sub report, and then put each subreport into a master report.
P Pat Hartman Super Moderator Staff member Local time Today, 18:51 Joined Feb 19, 2002 Messages 47,457 Sep 29, 2018 #3 Another possibility is a union query if they all have the same columns. We need to know more about what you are trying to show. Multiple subforms/subreport as Mindy suggested is probably what you are looking for.
Another possibility is a union query if they all have the same columns. We need to know more about what you are trying to show. Multiple subforms/subreport as Mindy suggested is probably what you are looking for.