Hi, I am trying to create a report that looks similar in nature to the attached document. I can't figure out what is the best approach to this. Below are details about my db.
- I want these grouped by by Rep name (as in the example) and then all relevant info populating based on info entered to their respective tables.
- I have a separate table for each of these sections in the report that are linked by a common rep number which is associated with just one rep.
I have been searching around and some people say to do subreports in the main report, but is that the best and/or easiest way to get to the end goal? Or would this be done better in another microsoft program?
Thanks.