totalling line values in a query before appending the data.

[Maclain]

we have a calculated field in an append query Line_Cost which eventually creates a purchase order.

We have to have a minimum order value of £1500.00, so, we need to total the values before running the append query.

best way?

 

[MarkK]

can't determine "best way" on so little info

 

[Minty]

This is all air code - as you haven't given us a huge amount to go on;
Save your append query to a select query. Call it current something like CurrentOrdereLines. Call the calculated field LineTotal
Run a query against CurrentOrderLines which has TotalOrderValue: Sum(LineTotal) as a calculated field.

 

[Maclain]

thanks for that.

Understand the information was shady

we will append to a temp table and use another query from there.

thanks again