I am pretty new to Access Reports.

I used the wizard to write a detail report that works well.

In the group footer, I would like to show the totals for each column
in my report.

So, I wrote a query that gets the totals, but I don't know how to get
it into my report.

Please explain to me how to get this query into my report so that I
can drag the fields into the correct places.

Thank you.

On Tue, 10 Oct 2006 20:23:10 GMT, Newbie <xyz_5591@yahoo.comwrote:

Create another report using this summary query. Save the report. Drop
it into your first report.
You may need to set Link Child Fields and Link Master Fields.

-Tom.

>I am pretty new to Access Reports.
>
>I used the wizard to write a detail report that works well.
>
>In the group footer, I would like to show the totals for each column
>in my report.
>
>So, I wrote a query that gets the totals, but I don't know how to get
>it into my report.
>
>Please explain to me how to get this query into my report so that I
>can drag the fields into the correct places.
>
>Thank you.