how to choose the last row in a report?

[sumukhreddy]

Name: Capture.PNG  Views: 16  Size: 8.6 KB  ID: 24120" class="thumbnail" style="float:CONFIG" />

hi all,

I've one question in reporting. I want to create a report from one query. The query result is as shown in the screenshot. In my report i only need the headings (filed names) and the last row (i.e., total row). How can i do that? is there any process? please help me.


Thanks a lot for your help.

[JoeM]

Simply make an Aggregate (Totals) Query (where you are taking the COUNT and AVERAGE of those fields), and base your Report on that.
It will just have one record if you create the Aggregate Query correctly, so your Report will just have the one record that you want.

I don't know if you have any other criteria, but that Aggregate Query will look something like:

SELECT Count([SUB DATE]), Avg([TIME SPENT])
FROM Table1;

[NTC]

Your post is somewhat subject to interpretation. If you seek a different record source then the advice by JoeM. On the otherhand if you already have a report with a detail section and the field titles in the header and summary math in the footer - then you can make the detail section not visible.

[sumukhreddy]

Simply make an Aggregate (Totals) Query (where you are taking the COUNT and AVERAGE of those fields), and base your Report on that.
It will just have one record if you create the Aggregate Query correctly, so your Report will just have the one record that you want.

I don't know if you have any other criteria, but that Aggregate Query will look something like:

SELECT Count([SUB DATE]), Avg([TIME SPENT])
FROM Table1;

Thank you very much for your help. I resolved it.