Displaying multiple cross-tab queries at the same time (1 Viewer)

N

NebraskaUser

Registered User.

Local time

Yesterday, 18:47

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?

 

Minty

AWF VIP

Local time

Today, 02:47

Joined

Jul 26, 2013

Messages

10,366

• 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.

 

P

Pat Hartman

Super Moderator

Staff member

Local time

Yesterday, 21:47

Joined

Feb 19, 2002

Messages

43,223

• 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.