Reporting Dilemma

[JLPSch]

Help! I have an ordering program that I am having trouble with in regard to creating reports.

Each order sometimes contains a backorder. These are contained in one record. The order has an Order Number and the backorder has an Order Number as well (separate field).

I want to create a report that will compile the order and backorder amounts by ship date and give a total. Because the order and backorder are in one record I'm not sure what to do. To compound the problem, the reports are done by month, and sometimes the ship dates for orders and backorders are different.

Any help or suggestions is most welcome!! Thank you!!

[LiveOak]

How about a little description of how many files, the file names, and the name and type of the fields they contain? -bd