Skip to Content
Former Member
Dec 04, 2007 at 11:24 AM

Totals in Query


Hi Everybody,

Question: Is it possible to have total of a specific column when I create a query?

In my example I created a query for all the costs related to a project (tables OPOR and POR1). I have the column of the price of every lineitem (Price from table POR1). Query works but I would need to have the total of the prices, possibly in the field called QI Direct Access Mtx1 (the one in the grid of the results). Is it possible?

Thanks in advance