Concatenate records or Continuous Form within a continuous form

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!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Instant Totals on Continuous Forms 4
A Continuous form field question 7
Continuous Form - adding a record 5
Count number of rcd on continuous form. 3
Instant Totals on Continuous Forms 0
Continuous Subform within a Continuous Form - Possible? 2
Still trying to use check boxes in a continuous form 4
Calculate conditiona total at bottom of continuous form. 4

Top