Combine Text Fields

[Andrew]

Is it possible to combine text fields from seperate reports that share the
same date?
The Fields i would like to combine are from seperate records that share the
same field [DailyReport]![InspectionComments.RE]. (I also have a
field[DailyReport]![ReportDate]). The problem is that [InspectorsCommentsRE]
must be combined eventually to one report that will represent a weekly
summary of the daily events as compiled by the
[DailyReport]![InspectorsCommentsRE] If so How is this accomplished?

 

[BruceM]

Data are stored in tables. Perhaps you meant "records" rather than
"reports" in the first sentence. Anyhow, use a query to combine fields as
needed.

I can't make out just what you are trying to do, but as a guess you may be
trying to group all records that share a common value in a particular field.
In that case you can group on that field in a report's sorting and grouping
dialog (View >> Sorting and Grouping).

 

[Andrew]

What I am trying to do is combine a memo field that may be on several reports
(TABLE) that share the same date, into one field in another table. Example: A
reviewer of work will make comments on activites as reported by inspectors,
theese comments are an annotated version of work (the reviewers comments are
in a field in the daily table). I would like to know if it is possible to
pull the reviewers comments from each daily report and combine them into one
field in another table table. (From there the data from the new "combined
comments table" can be queried to a report that represents a weekly "Brief".)
--
Andrew
H.W. Lochner

Data are stored in tables. Perhaps you meant "records" rather than
"reports" in the first sentence. Anyhow, use a query to combine fields as
needed.

I can't make out just what you are trying to do, but as a guess you may be
trying to group all records that share a common value in a particular field.
In that case you can group on that field in a report's sorting and grouping
dialog (View >> Sorting and Grouping).

Is it possible to combine text fields from seperate reports that share the
same date?
The Fields i would like to combine are from seperate records that share
the
same field [DailyReport]![InspectionComments.RE]. (I also have a
field[DailyReport]![ReportDate]). The problem is that
[InspectorsCommentsRE]
must be combined eventually to one report that will represent a weekly
summary of the daily events as compiled by the
[DailyReport]![InspectorsCommentsRE] If so How is this accomplished?

 

[BruceM]

The memo field is in a table. The report only displays it. You may be able
to use a Totals query to achieve the general effect of combining several
fields, but first try grouping the report by the date field. Add a group
header, put the date field into the group header, and run the report. It's
much easier, and should achieve the same result.

What I am trying to do is combine a memo field that may be on several
reports
(TABLE) that share the same date, into one field in another table.
Example: A
reviewer of work will make comments on activites as reported by
inspectors,
theese comments are an annotated version of work (the reviewers comments
are
in a field in the daily table). I would like to know if it is possible to
pull the reviewers comments from each daily report and combine them into
one
field in another table table. (From there the data from the new "combined
comments table" can be queried to a report that represents a weekly
"Brief".)
--
Andrew
H.W. Lochner

Data are stored in tables. Perhaps you meant "records" rather than
"reports" in the first sentence. Anyhow, use a query to combine fields
as
needed.

I can't make out just what you are trying to do, but as a guess you may
be
trying to group all records that share a common value in a particular
field.
In that case you can group on that field in a report's sorting and
grouping
dialog (View >> Sorting and Grouping).

Is it possible to combine text fields from seperate reports that share
the
same date?
The Fields i would like to combine are from seperate records that share
the
same field [DailyReport]![InspectionComments.RE]. (I also have a
field[DailyReport]![ReportDate]). The problem is that
[InspectorsCommentsRE]
must be combined eventually to one report that will represent a weekly
summary of the daily events as compiled by the
[DailyReport]![InspectorsCommentsRE] If so How is this accomplished?