Shipname, Shipaddress etc.

[kokopops]

Hello
In my report (which is an invoice) if the Shipname, Shipaddress etc are the
same as the Name, Address etc on the invoice I would like to just show "Same".
Is there an Iif statement that will do this?

 

[Klatuu]

There are a couple of ways you can do this. The easiest (if you are not
familiar with VBA) is to use the Control Source property of each text box
where you display a shipper data element, for example, you probably have at
least two, one for shipper name and one for shipper address. If you have
more, you will need to do it for each control:

=Iif([ShipName] = [Name], "Same", [ShipName])

=IIf([ShipAddress] = [Address], "Same", [ShipAddress])

 

[kokopops]

This is what I had tried and thought I had made a mistake. It always replies
with the [Shipname] even if it is the same as the [Name]. There must be a
problem further back in my query or table. Thanks for your reply anyway.