Calculate Query

[handlebars]

I have a query that I cannot get to work that adds up line totals, then adds additional percentage charge, and subtracts a percentage discount from that total.

Should my solution be a query of a query of a query (seems messy) or can anyone suggest an appropriate way of doing this.

I have tried creating this as one query, but am getting errors.

Will post back the exact message if this is needed (do not have access to database at the moment).

Maybe a very obvious answer, but would be v useful!


Andrew

 

[Clipper2000]

SELECT Field1, sum(field2) as A, sum(field3Percent) as B, sum("enter your expression here") as C
From YourTable
Group By Field1