By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
446,397 Members | 1,467 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 446,397 IT Pros & Developers. It's quick & easy.

report building

P: n/a
I am building a report and the results of the detail section have to
be in a certain order, how can I do this? I also want to make a field
that displays a result that is based on multiple retrieved records.
Nov 12 '05 #1
Share this Question
Share on Google+
3 Replies


P: n/a
On 17 Feb 2004 15:09:23 -0800, Great_milenko wrote:
I am building a report and the results of the detail section have to
be in a certain order, how can I do this?
Right click on the Detail section of the report, and choose
Sorting/Grouping fromthe menu. Choose the field you wish to sort on and the
sort order to use (ASC, DESC)
I also want to make a field
that displays a result that is based on multiple retrieved records.


You'll need to be more specific before determining what you can do.

--
Mike Storr
www.veraccess.com
Nov 12 '05 #2

P: n/a
Mike Storr <st******@sympatico.ca> wrote in message news:<14*****************************@40tude.net>. ..
On 17 Feb 2004 15:09:23 -0800, Great_milenko wrote:
I am building a report and the results of the detail section have to
be in a certain order, how can I do this?


Right click on the Detail section of the report, and choose
Sorting/Grouping fromthe menu. Choose the field you wish to sort on and the
sort order to use (ASC, DESC)
I also want to make a field
that displays a result that is based on multiple retrieved records.


You'll need to be more specific before determining what you can do.

Ok lets say I have made a report with a field named number and the
result it displays is like this 1, 2, 3, 4, 5, 6, 7 ; now what I want
to do is put it like this 7, 2, 1, 6, 4, 5, 3; and have an extra field
that now shows the average of 7, 2, 1 & 6, 4, 5 etc.
Nov 12 '05 #3

P: n/a
On 18 Feb 2004 00:33:54 -0800, Great_milenko wrote:
Ok lets say I have made a report with a field named number and the
result it displays is like this 1, 2, 3, 4, 5, 6, 7 ; now what I want
to do is put it like this 7, 2, 1, 6, 4, 5, 3; and have an extra field
that now shows the average of 7, 2, 1 & 6, 4, 5 etc.


Doing this on arbitrary lines in a report would be rather hard. Something
would need to be different in order to group the desired records together.
If such a thing exists, then all you need to do is set a grouping level on
that value, then include an unbound textbox in that grouping sections
footer. Set the controlsource for this textbox to =Avg(FieldName) It will
average all the records in that group. Make sense?

--
Mike Storr
www.veraccess.com
Nov 12 '05 #4

This discussion thread is closed

Replies have been disabled for this discussion.