Creating multiple groups in a report 1

[rcoutts]

I'm creating an Invoice report that I'd like to look something like this:

REIMBURSABLES
     Drawing Reproduction    .  .  .   100.00
     Mileage                 .  .  .     4.35
     Supplies                .  .  .    10.00
     Postage                 .  .  .     5.25
     Tolls & Parking         .  .  .     8.00

CONSULTANTS             
     Structural Engineer     .  .  .  1000.00
     Interior Designer       .  .  .   100.00
[\code]
My problem is that sometimes these amounts are zero, in which case I don't want to list them.  But, I don't want my Invoice to look like this:
[code]
REIMBURSABLES
     Drawing Reproduction    .  .  .   100.00
     Supplies                .  .  .    10.00




CONSULTANTS             
     Structural Engineer     .  .  .  1000.00
     Interior Designer       .  .  .   100.00
[\code]
With big spaces where the zero amounts are.  What is the preferred way to do that?  Currently, each category (Reimbursables, Consultants, etc.) has a corresponding Query that sums its subcategories (Mileage, Supplies, etc.)  I'm guessing that I should create a Table with (3) columns and generate a report that uses Grouping.  I experimented with that and it works nicely, and I even altered my queries so that they each generate the three columns I need, but I need to append them into a single table, apparently.  What's the best way to do that?  I tried changing the queries to Append Queries, but you apparently can't append the results of one query to another (is that true?)  Should I be looking at a Make-table Query?

Thanks in advance,
Rich

 

[MichaelRed]

Union Query.

MichaelRed
m.red@att.net

There is never time to do it right but there is always time to do it over