Create paragraph format of data

[Guest]

I am trying to pull data from a master table that has several fields. I want
to pull one field, then add a period, then a space, and then data from the
other field. This is what I have tried:

Master Table Fields include:
Type of Observation: "Major Deficiency"
Observation: "Person did not do anything"
Supporting Data: "They ignored their boss"

I want it to come out like this:

Major Deficiency. Person did not do anything. They ignored their boss.

This is the expression I am using:

=[Type of Observation] & ". " & [Observation] &". " & [Support Data]

And I get an "Error".

What am I doing wrong?

 

[Duane Hookom]

You used [Support Data] rather than [Supporting Data].
Also make sure the name of the control is not the name of a field.

 

[Guest]

You don't say if your "report record source" is a table or a query, but
here's what I ran into: If your report's record source is a query, then then
any field(s) you reference must be included in the query field list.

Also, what kind of "error"?

Also, I just noticed that in your "table" you list "Supporting Data", but
your expression indicates "Support Data" (notice spelling differeinc in
"Supporting" vs "Support".

Hope this helps.