substituting field in a query with another field in the same query

[WAVP375]

I've downloaded a file from a local government with has among other fields, Name, Address1, Address2, Address3 which is city and state, and zip.


I'm attempting to create a query that will move concatenated Address3 and zip to address2 if address2 is blank. Then blank address3.

I have attempted to do this in the print object without any success figuring I needed to do it in a query but so far that too is unsuccessful. I can create an expression in the query that determines that the field is blank but have not been able to move the address3 to it.

Looking for a better way or a head in the right direction

Thanks

[WAVP375]

Sorry to bother. I Have just figured it out.

Thanks

[pbaldy]

Posting your solution could help other users. For what it's worth, I would not move the data around, I'd handle the potentially empty field on forms/reports. That way address3 is consistent in what it holds. You know your overall situation though.