Making certain fields "invisible" in Queries

[jeprox]

I have created a query for my Shipping Log.

In the standard order forms in Access, the Bill TO is usually the Ship To unless you enter a specific Ship To when entering the order.

From my query , I have both the Bill To and Ship To fields available.

In my actual report, I dont want the Bill To Address to come up if there is different Ship TO name.

Is there a command that I can type in the Criteria field?

Thank you very much.

JEP

 

[MakeItSo]

You might help yourself with a modification of your query.
Add the following:

BillAddress: If([BillTo]=[ShipTo];[BillTo];"&quot
And refer to [BillAddress] instead of BillTo in your orderform / report.
This way, the BillTo will only have a value, when it is the same as the ShipTo; else it will be empty.

Does that help you?

Cheers,
MakeItSo