Shipname, Shipaddress etc.

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

kokopops - 21 Apr 2008 16:35 GMT

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?

Reply to this Message

Klatuu - 21 Apr 2008 17:21 GMT

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])

Signature

Dave Hargis, Microsoft Access MVP

> 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?

Reply to this Message

kokopops - 21 Apr 2008 18:05 GMT

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.

> 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
[quoted text clipped - 5 lines]
>
> =IIf([ShipAddress] = [Address], "Same", [ShipAddress])

Reply to this Message