Trouble with quote follow up report

[mkdrep]

Please see attached (.pdf). Currently, I can accomplish having my report printout as shown on page 1.
Goal is to have same style report except to have the project notes print out underneath all the quotes. I have simply typed in how the notes would look like but I haven't been able to accomplish it.
Page 3 shows what happens when I add my table [Job Process] to the query. Instead of just (10) records (quotes) showing up in the report, (130) records show up. I didn't both trying to create a report using this query because I knew it wouldn't accomplish what I wanted.
Any help would be appreciated. Thank you. Mark

 

[theDBguy]

Hi. Just a thought, have you tried using a subreport?

 

[mkdrep]

No, it never dawned on me to try that. I'll research that option and let you know. thx for the suggestion

 

[theDBguy]

No, it never dawned on me to try that. I'll research that option and let you know. thx for the suggestion

You're welcome. Hope it works. Please let us know how it goes.

 

[mkdrep]

You're welcome. Hope it works. Please let us know how it goes.

I was able to design the report exactly the way i needed. Thank you again for your help

 

[theDBguy]

I was able to design the report exactly the way i needed. Thank you again for your help

Congratulations! Good luck with your project.

 

[arnelgp]

you can also use Grouping on your Report without having another subreport.