Overview Query

[mveijndh]

Hi,

I need to make a comprehensive line query of our order book. The query should list the following
Order number (easy)
Order description (easy)
Order Value (easy)
total Invoiced value (multiple invoices)
Total cost of time spent (multiple visits)
Total cost of mileage (multiple visits)
Total cost of expenses (multiple units)
total cost of time, mileage and expenses

What is the best way to solve this?

 

[plog]

What's a line query?

Can you demonstrate your issue with data? Provide 2 sets:

A. Starting sample data. Include field and table names and enough data to cover all cases.

B. Expected results based on A. Show what you expect to end up with from your query when you feed it the data in A.