sum to totals

[lancemeroniuk]

Hi all...

I have a querry that selects date: Fee: Other amount:

At the bottom of these colums I would like the total of each colum.. I tried a cross tab querry.. but did not get the results I wanted.

Any suggestions???
Thanks in advance

Lance

 

[jrbarnett]

Hi,

With a query you won't be able to put totals on the bottom. My suggestion is to create a report based on the query and put textboxes bound to =Sum(Fieldname) to produce your totals.

John