Prev: Using ADO Recordset for Source of Access Report in .MDB file
Next: border style alignment
From: tinal on 26 Jun 2008 10:28
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

From: Marshall Barton on 26 Jun 2008 10:59
tinal wrote:

>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...."


You could use a text box expression like:

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

--
Marsh
MVP [MS Access]
 | 
Pages: 1
Prev: Using ADO Recordset for Source of Access Report in .MDB file
Next: border style alignment