Hey everyone,
Little bit of background, I literally graduated from uni three weeks ago, and started my new job immediately. I work as an Actuary in a small firm without any sort of programming or computer specialists. I was working on a giant project involving millions of rows of data in Excel, and asked my immediate boss if they had ever considered using Access. He said yes, but that no one in the company had enough experience, and he invited me to make that my pet project. One thing led to another, and now I am working on switching over all of our administrative processes from Excel into Access, like tracking clients, meetings, tasks, billing, etc. Unfortunately, I have never used Access until this week, so I am flying by the seat of my pants here.
What I've created so far are three tables: A listing of our clients and their details, a list of our upcoming client meetings (we are a consulting firm), and a list of projects we are working on for each client. What I am trying to do right now for a report is have our meeting notes automatically assembled from the information in the tables. This involves pulling the meeting date and client, finding the corresponding projects, the notes to those projects, etc. I've created a query that works great so far, but the biggest issue is this; most of our clients have multiple projects being presented at each meeting, so this involves pulling in multiple projects into one field. I wanted each product on it's own line, which I managed to do with the ConcatRelated() function that seems to be very common, and simply hitting "enter" in the "delimit by" field. This makes each project appear on a separate line. My problem is that my report completely ignores this, and treats the newline like a space instead. What I can't figure out is how to make those projects appear on independent lines.
Below I have tried to make some representations of my tables and query:
tblClients
ID Client ID Client Name Etc... 1 005 Name 005 2 012 Long Name 012
tblProjects
ID Client ID Project Meeting Date Etc... 1 005 Task1 6/3/17 2 005 Task2 6/3/17 3 005 Task3 6/3/17 4 012 Task4 6/5/17 5 005 Task5 6/10/17 6 005 Task6 6/10/17
tblMeetings
ID Client ID Meeting Date Etc... 1 005 6/3/7 2 012 6/5/7 3 005 6/10/17
And my Query looks like this:
Meeting Date Client ID Projects Etc... 6/3/17 005 Task1
Task2
Task36/5/17 012 Task4 6/10/17 005 Task5
Task6
However in my report, the Projects get listed like this:
Meeting Date Client ID Projects Etc... 6/3/17 005 Task1 Task2 Task3 6/5/17 012 Task4 6/10/17 005 Task5 Task6
How can I get it to show up in my Report like it does in the query?