Summary Reports

[Nixx1401]

Hi there,

I have an dbase which keeps track of money receive and spent for clients. The money received can be varying currencies. I would like to have a report which produces the totals of each currency for each client without the transactions that occured.

eg

Tom Brown



USD BBD GBP XCD
$40.00 $20.00 $50.00 $10.00

this will continue listing all the clients

[June7]

What is the table structure? Is there a single field for the amount and another field for the currency type?

Consider a CROSSTAB query.

[Nixx1401]

yes there are single fields for amount n currency.

[June7]

Did you try CROSSTAB? There is a wizard to help.