I am stuck with what to do, and may have to create a few tables to fix the problem, but I thought that before I did that I would consult with the experts!
I am generating a report based on a query of a table that has three fields that can contain multiple values. For testing purposes, I have 4 records that should be shown, grouped by primaryRep. The problem lies in the fact that the report seems to want to seperate those multiple value fields out onto a seperate line for each entry. For example, these are codes associated with the record entry, like A1001, A1002, B4398, C4938, etc... Each of these shows up on a seperate line so the report is something like 30 rows long, even though there are only 4 records total.
In my query, I even deleted the .values column for each of the three fields and strictly running the query will show four records, but even though the report is based off of the query, it still returns a multitude of rows for each "code" (which when combined with two other fields makes the report grow exponentially!).
From what I have seen, I will need to break it up into different tables instead of multiple value fields. Does anyone know a way around this?
BTW, running access 2007.
I am generating a report based on a query of a table that has three fields that can contain multiple values. For testing purposes, I have 4 records that should be shown, grouped by primaryRep. The problem lies in the fact that the report seems to want to seperate those multiple value fields out onto a seperate line for each entry. For example, these are codes associated with the record entry, like A1001, A1002, B4398, C4938, etc... Each of these shows up on a seperate line so the report is something like 30 rows long, even though there are only 4 records total.
In my query, I even deleted the .values column for each of the three fields and strictly running the query will show four records, but even though the report is based off of the query, it still returns a multitude of rows for each "code" (which when combined with two other fields makes the report grow exponentially!).
From what I have seen, I will need to break it up into different tables instead of multiple value fields. Does anyone know a way around this?
BTW, running access 2007.
Last edited:
