shipping labels

[LearnersPermit]

Good afternoon. I have a question that has stumped me for the past week. My problem is that I have a database which handles orders and the user can print shipping labels for pending orders to the billing address of the clients.

The majority of the clients have the same address for billing and for shipping. The default address for most clients is a shipping address that is "Same as Billing" in one of the fields. The balance of the fields are left blank unless there is a client with a different shipping address.

What I am able to do is generate a label for billing address. What I have not yet accomplished is toe be able to also generate the label for those customers with a different shipping address. I can create a separate label report for them, but that's not what the client wishes.

Any suggestions for the few who have a different shipping address and require both a shipping and a billing label?

 

[JerryDennison]

Create some unbound fields in your query that will look at the Same As boolean field then populate with the appropriate address.

txtAddress1: IIF([SameAsBillingField], BillingAddress1, ShippingAddress1)

txtAddress2: IIF([SameAsBillingField], BillingAddress2, ShippingAddress2)

.....

 

[GingerR]

how about using a UNION query? i'm not so slick at it, but make a query with the BILLING SAME AS SHIPPING, then a query with BILLING DIFF FROM SHIPPING then a third query that's a UNION query that smashes them together. use this query as the record source for your label report.