G
Guest
I am trying to pull data from different fileds in a table, called Master
Table. I want to create a report that would output this information in a
pragraph form like below...
The epsression I used is this:
= [MasterTable]![Type of Observation] & ". " & [MasterTable]![Observation] &
". " & [MasterTable]![Name]
This is what I want it to look like:
Bad Finding. Person did not do anything and blah, blah, blah, blah, blah,
blah, blah, blah, blah, blah, blah, blah, blah, blah, blah, blah, blah, blah,
blah, blah, blah, blah, blah, blah, blah, blah, blah, blah, blah, blah, blah,
blah, blah, blah, blah, blah, blah, blah, blah, blah, blah, blah, blah, blah,
blah, blah, blah, blah, blah, blah, blah, blah, blah, blah, blah, blah. POC:
John Doe.
The table fields are "Type of Observation", "Name", and "Observation"
Type of Observation: Bad Finding
Name: John Doe
Observation: Person did not do anything and blah, blah, blah, blah, blah,
blah, blah, blah, blah, blah, blah, blah, blah, blah, blah, blah, blah, blah,
blah, blah, blah, blah, blah, blah, blah, blah, blah, blah, blah, blah, blah,
blah, blah, blah, blah, blah, blah, blah, blah, blah, blah, blah, blah, blah,
blah, blah, blah, blah, blah, blah, blah, blah, blah, blah, blah, blah
All I get is an error. please help!
Table. I want to create a report that would output this information in a
pragraph form like below...
The epsression I used is this:
= [MasterTable]![Type of Observation] & ". " & [MasterTable]![Observation] &
". " & [MasterTable]![Name]
This is what I want it to look like:
Bad Finding. Person did not do anything and blah, blah, blah, blah, blah,
blah, blah, blah, blah, blah, blah, blah, blah, blah, blah, blah, blah, blah,
blah, blah, blah, blah, blah, blah, blah, blah, blah, blah, blah, blah, blah,
blah, blah, blah, blah, blah, blah, blah, blah, blah, blah, blah, blah, blah,
blah, blah, blah, blah, blah, blah, blah, blah, blah, blah, blah, blah. POC:
John Doe.
The table fields are "Type of Observation", "Name", and "Observation"
Type of Observation: Bad Finding
Name: John Doe
Observation: Person did not do anything and blah, blah, blah, blah, blah,
blah, blah, blah, blah, blah, blah, blah, blah, blah, blah, blah, blah, blah,
blah, blah, blah, blah, blah, blah, blah, blah, blah, blah, blah, blah, blah,
blah, blah, blah, blah, blah, blah, blah, blah, blah, blah, blah, blah, blah,
blah, blah, blah, blah, blah, blah, blah, blah, blah, blah, blah, blah
All I get is an error. please help!