Access 97 Report custom SUM ?, please help. 1

[suntsu]

Hi There,

Need help with this one, so far am lost

I have a report running from a crosstab query, grouping on the following fields, Customer & Year. Now what I need is to be able to make calculations within the customer footer, something like this:

=sum([InvoiceTotal]) where (([year])=1999)

and so on.

I do not want to use subreports, and must keep all the calculations in the customer footer.

again, please help

Best Regards,

Sun Tsu.

 

[JoeMiller]

You can use DSum to accomplish this, this would be the general format:

=DSum("[InvoiceTotal]","MyQueryName","[Year]='1999' AND [CustomerID]=[CustomerID]&quot Joe Miller
joe.miller@flotech.net

 

[suntsu]

Thanks again Joe,

First time around these parts and already everyone seams very helpful/friendly

I have never used any of the 'D' functions before (outwith Excel) I look forward to seeing it work first time.

Thanks Again,

Sun Tsu.