Concatenate records or Continuous Form within a continuous form

  • Thread starter Thread starter Greg Hill
  • Start date Start date
G

Greg Hill

The problem here originates with the "Group By" total in a
Query. What I really want the query to group by the
Measurement field, then, for each team that uses the the
Measurement, combine or concatenate the values of the
Comments field. Sort of like doing a sum, except the Sum
field is a text field. A solution I tried and failed at
was putting a continuous form of Comments within a
continous form of Measurements, but Access said I wasn't
allowed to do that. The data is in 2 tables, with the
measurements being on the 'one' side, and the Comments
being on the 'many' side. Thanks for any ideas!
 
Back
Top