DSum on Access Query
Posted on 2007-12-04
I've been advised to use dSum in a form rather than a query to sum the totals of a field, simply because the sum query prevents updates to the form you are using.
Is DSum VB or an SQL expression?
Here is how I want to use it. The form will be in dataview and show a list of all the account. So I don't want to use a form showing single accounts with a subtable. I've already got this screen working great.
First table (tbl1)
customer no. (key)(link)
Release order (yes/no)
I want the form to add up all the individual cheques from table 2 and display them on 1 form with all the info from table 1, so the user can see if the cheques received => than the order value. Then they can click release order.
If I use the sum query to add the cheques together, the tick box will not work because a query is being used and access doesn't like that.
Please can somebody help me learn a new trick?