microsoft.public.access.reports

Try create a text box in the Report Header section:
Name: txtRptAmt
Control Source: =Sum([Amount])
Add a text box to the Country Group Header
Control Source: =Sum([Amount])/txtRptAmt
Format: Percent

--
Duane Hookom
Microsoft Access MVP


"Hallgeir" wrote:

> In addition. to the detail section with "District", I have one group section
> "Country".
> My report looking something like this:
>
> ----------------------------------------
> Country District Amount Percent
> ----------------------------------------
> Norway
> A 8 80%
> B 2 20%
> Sweden
> B 4 40%
> C 3 30%
> D 3 30%
>
> My problem is the Percent column. I want to show amount in percent for each
> Country. Hope you understand what I mean. Appreciate any suggestions.
>
> --
> regards
> hallgeir
>
>
>