Display two records that belong to the same ID on same page (1 Viewer)

B

basshead22

Registered User.

Local time

Today, 12:33

Joined

Dec 17, 2013

Messages

52

• Jun 2, 2017

• #1

Hello All! it's been awhile since I've posted.. you guys are always helpful.

My problem: Trying to get two records that have the same ID# and same fields to show on the same report. Almost like a continuous form.

I have attached images.

Thanks in advance!

 

Attachments

• 
  Page 1.jpg

  44.9 KB · Views: 95
• 
  Page 2.jpg

  69 KB · Views: 121
• 
  Query.jpg

  91.4 KB · Views: 93

isladogs

MVP / VIP

Local time

Today, 20:33

Joined

Jan 14, 2017

Messages

18,219

• Jun 2, 2017

• #2

Have you considered using a subreport to do this?

 

B

basshead22

Registered User.

Local time

Today, 12:33

Joined

Dec 17, 2013

Messages

52

• Jun 2, 2017

• #3

It is actually a sub report (details) to the Main report. See pic of Main report.

 

Attachments

• 
  main report.jpg

  55.4 KB · Views: 88

Last edited: Jun 2, 2017

isladogs

MVP / VIP

Local time

Today, 20:33

Joined

Jan 14, 2017

Messages

18,219

• Jun 2, 2017

• #4

Not sure how the new image helps ....

Looking at the original images - why not move the 2nd & 3rd sections (SPL Services Material) to another subreport and place it below the one you want on page 1

Its difficult to advise further without knowing how your data is structured.
The query image doesn't explain how you've made your report(s)

However as you know how to do subreports, it shouldn't be difficult to solve