RV,
I am a little confused with your response. What do you mean by use the format function?
I have two diffrent tables.
Complaints (Which houses the complaint and orders are placed).
Invoices - Stores the financial data for invoice payments.
The orders are placed and the date is recorded when the complaint date is entered. I do not use a separate order date.
The invoice date is a separate date. This is done because an invoice may come in a month or two later than the date of the complaint.
What I need to do is get the cost of the order (Cost of parts shipped), and the cost of the invoice if there is one.
For example - I need all the order costs for June plus any invoices that were paid in June regardless when the complaint was recorded.
Thanks