Tina Norris Fields
tinanfields at torchlake.com
Mon Dec 8 14:02:54 CST 2008
Hi, I'm trying to craft a report that lists the addresses of members of an organization. Some people have year-round addresses; some people have summer and winter addresses. The list is supposed to be something like this: (this whole message is set up in fixed width font to make the addresses all line up on tabs) John Anderson 123 Main St (231) 555-2323 MyTown, MI 49676 janderson at someisp.net Winter 465 Wisteria Ln (416) 555-1776 OtherTown, OH 48332 Zone: A - Clearwater Twp Of course many members will not have a winter address, so I want to display that portion only if the condition is met that the address season is "WIN" Some addresses will have only street addresses, some will have only PO Box addresses, some will have both - so there's an Addr1 field and an Addr2 field. The CanShrink property will take care of getting rid of the blank lines if either Addr1 or Addr2 is empty. I had thought I would like to put the full address into an Iif expression, concatenating everything together with carriage returns and line feeds where appropriate, but that is not working - if I put in VbCrLf in my expression, Access treats is as a parameter and asks for the value. Darn! It would be really helpful to me if anyone can direct me to examples of this sort of report. TIA TNF