T
TC
I have one query that extracts a number of records with amounts of money. In
a second query based on it I narrow it into one line per client with a total
of the money field ('feeval'). Then I generate a report from the second table.
The trouble is I don't seem to be able to get a big total at the bottom, and
also I want to on each line put the percentage the amount is of the whole
total. Can someone please help me as I have no manuals, no experience and no
training and no support from the 3rd party people either.
PS I would also like to be able to limit the report to display only a set
number of lines?
a second query based on it I narrow it into one line per client with a total
of the money field ('feeval'). Then I generate a report from the second table.
The trouble is I don't seem to be able to get a big total at the bottom, and
also I want to on each line put the percentage the amount is of the whole
total. Can someone please help me as I have no manuals, no experience and no
training and no support from the 3rd party people either.
PS I would also like to be able to limit the report to display only a set
number of lines?