How to add multiple queries in one report (1 Viewer)

N

Nastaran

New member

Local time

Today, 15:40

Joined

Jun 13, 2019

Messages

7

• Jun 14, 2019

• #1

Hi!

I have 3 queries that I Want to make just one report of them, now when I want to add subreport, I cant add queries to subreport, just I can add form and table.

TNX

 

June7

AWF VIP

Local time

Today, 03:10

Joined

Mar 9, 2014

Messages

5,470

• Jun 14, 2019

• #2

Right, build a form with query as RecordSource.

 

theDBguy

I’m here to help

Staff member

Local time

Today, 04:10

Joined

Oct 29, 2018

Messages

21,467

• Jun 14, 2019

• #3

Hi. June might have meant, build a report based on the other query and then use this report as a subreport. Do it again for the third query.

 

June7

AWF VIP

Local time

Today, 03:10

Joined

Mar 9, 2014

Messages

5,470

• Jun 14, 2019

• #4

Ooops, yes, meant report.