Hi, don't know if this is too easy, but eitherway, I'm struggling with it so...

I've made a report to send monthly invoices. For each costumer, I have two adresses, one showing the street and matching state, zipcode, one showing the PO Box with matching state, zipcode. If I show them both, it's a bit too much on the report.

I only want to show the street and matching data if there's no PO Box available. Can't do this with a query (I think) because all records need to be involved, sometimes they just have to be hidden, at least some of it.

any ideas?

Thanks

Welcome to UA

Can you provide us more info => tablestructure, records-example, result-example
So we can better help you ...

Greetz from Belgium (IMG:http://www.utteraccess.com/forum/style_emoticons/default/compute.gif)

Luc aka Kuifjexx