How to print 2nd address without affecting other original address

[gilinnc]

Here is my first time posting (no head rubbing please).

I have an account list (local businesses) with their address of businesses. However, few of these businesses have a secondary address to mail bills to.

I've created a table that contains regular address and Mail to address. In my report, I have listed each busines address and the sub-total of charges of each address. However, I am unable to find a way to add "Mail To" address in the detail line. I am able to add the Mail-To address in the detail line, but I am not able to prevent other business that does not have Mail-To to be spaced out so much on the report.

Instead of 1-1/2 page report, now I get 4 page of report. Too many excessive 'blanks' on business that does not have "Mail-To" address.

As an example below:

ABC to XYZ Co.
123 Main Street 6/1/2011 $10.00

ABC to XYZ CO. Total Due: $10.00

CDE to JKL Inc.
200 Main Street 6/2/2011 $10.00
200 Main Street 6/7/2011 $10.00
Mail to: 500 AnyStreet, ND 12345

CDE to JKL Inc. Total Due: $20.00

NOP Enterprise
300 Main Street 6/15/2011 $10.00
300 Main Street 6/18/2011 $10.00

NOP Enterprise Total Due: $20.00

the above is what I am attempting. However, the Mail To field is placed after each detail address with amount due which adds "blank" lines to those that does not have Mail-To address.

Does anyone have an idea of how to do what I am trying to do? Examples?

Thank you for all your help.

 

[jdraw]

Perhaps you could base your report on a query and use some sort of IIF statement

..... AddrToUSE:iif(IsNull(MailTo),RegularAddr,MailTo)

Just a thought, but you could try a sample as a test to see if it helps.

Look for immediate IF statement IIF

syntax generally

iif(condition, DoThis IF Condition is True, Do This if Condition is False)

 

[gilinnc]

jdraw -

thank you for that tidbits. Yes my report (created through wizard) links to the query that I created that select fields from 2 tables (one with account number & business info [address & mail-to], the 2nd table account number and amount column)

Where in the query do I put this IIF condition? This is very new to me.

Again, thank you all for tips & help.

Gil