Simple Query

[Krish]

I am attaching to an external database using ODBC to run a query. The
external database store the sales information. It has the customer number,
date of Invoice, Order number, product number, line number on the Invoice,
quantity, cost, selling price and the total margin on the entire Invoice. As
you can see the total margin is repeated in every line until the next
customer information. I am trying to extract the total margin less than
certain dollar value and use that information to create a report by customer
and date or Invoice number. What is the formula I need to use to extract the
total margin?

Thanks for the help.
Krish

 

[[MVP] S.Clark]

Select OrderNumber, Margin from tablename Group by OrderNumber, Margin