Hi,

In VS2005 I have created in the dataset a query to return Total where total is the sum of 5 fields in the database table.

eg each customer has a circuit reading 1,2,3,4 and 5. How can I assign the total field in the same customer table to be this Query. ie if I change the figures in either of the circuit reading fields the total will be updated?

When I run the query preview it returns the correct value as total but I cannot find out how to get this to work in my table Total field. Thanks a lot for the help.

Phil