Originally Posted by Phil2006
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