Hi Mark
thanx for the advice, but i have no clue on how to use sql. what i need to do is get a layout like below:
--------Items Serviced--------
Make Model Serial#
------------------------------
XYZ A123 12345
ABC B321 98765

--------Parts Used------------
Qty Part# Desc Price
------------------------------
1 67584 Spring 1.25
2 99495 Lever 9.99
Parts Total 11.24

-----------Labor--------------
Date Time Rate Total
------------------------------
07/05/00 1hr 25.00 25.00
Labor Total 25.00
------------------------------

-----------Description--------
Disassembled, repaired and (memo field)
reassembled. Tested working Ok.
------------------------------
Invoice Total 36.24

this is far simplified, but gives the idea. each column under each section is a field from a different file. given this and the report designer has only 1 details band or area, i am lost.

i know you guys also have lives to live and any detailed help will be a blessing!