Display certain data in a report depending on value of field in ta

  • Thread starter Thread starter tinal
  • Start date Start date
T

tinal

I have 2 tables in my database - House Details and Owner Details. As the
names suggest the House table lists all properties in a given area. The
owner table gives all details of owner, name, address etc.

In the House Table I have a field called "Owner Type" which can be either
Full Owner or Partial Owner.

I cam creating a report based on a query from both tables. Is it possible
to display in the report certain text depending on whether the Owner Type is
Full or Partial i.e. I want to say at the top of the report if it is a Full
Owner "As you are the registered owner....." and if its a Partial Owner I
want to display in the report "As you are one of the registered owners...."

I hope this is making sense to you

Thanks
Martina
 
tinal said:
I have 2 tables in my database - House Details and Owner Details. As the
names suggest the House table lists all properties in a given area. The
owner table gives all details of owner, name, address etc.

In the House Table I have a field called "Owner Type" which can be either
Full Owner or Partial Owner.

I cam creating a report based on a query from both tables. Is it possible
to display in the report certain text depending on whether the Owner Type is
Full or Partial i.e. I want to say at the top of the report if it is a Full
Owner "As you are the registered owner....." and if its a Partial Owner I
want to display in the report "As you are one of the registered owners...."
Click to expand...


You could use a text box expression like:

="As you are " & IIf([Owner Type]="Full Owner", "the
registered owner", "one of the registered owners") & ....
 
Back
Top