Report

S

specialk

We just had a database built for us in access. I opened a report and notice
a problem with a section pulling in our clientcompany.

below is how she has it pulling it in. All of the wording is there but no
company name. Was wondering if someone could look at the below coding and
tell me waht is wrong.

="Phoenix Investigations, Inc., was hired by " & [clientCompany] & " to
conduct an investigation on the above referenced address."

She has this put in the control source in the properties of the field.

Hope this makes since.
 
T

TonyT

Hi specialk,

Is clientCompany a field in the reports recordset? If so does it always have
a value?

If the above 2 questions are yes, then it should work ok.

TonyT..
 
Top