468,110 Members | 1,595 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 468,110 developers. It's quick & easy.

Sorting a REPORT by a Calculated Field in group header

I have a report in which each record is about work booked to be done by my
company for a client. Each day of work is represented by one record.

The report is grouped by CLIENT -- so each page has a group header with the
client's info, and under that a detail of work done or to be done within the
date range specified when opening the report. The CLIENT Group footer has
totals and other calulated fields...each page is that particular clients
invoice for the spcified period.

On the group header I have a calculated control INVOICE DATE which is MIN
(DATE)...that is, it returns the earliest date within the detail.

In the sorting and grouping box, there is only the option to sort the
clients alphabetically...and what I REALLY want to do is sort them by
INVOICE DATE.

Hopefully someone can help me with this....

Pat S
Nov 12 '05 #1
0 2575

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

1 post views Thread by Nathan Bloomfield | last post: by
1 post views Thread by Jon via AccessMonster.com | last post: by
2 posts views Thread by Tim Marshall | last post: by
3 posts views Thread by pat | last post: by
4 posts views Thread by Jana | last post: by
8 posts views Thread by sara | last post: by
1 post views Thread by Solo | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.