Reports: Sorting field order of source tbl/query for report

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have Access2002. I need to sort the field order of source fields that are
dynamic. For e.g.: I have a chart that displays the last 3 month of a
quantity - every month that passes brings on a new month & disregards the
old. The current field arrangement is: Manager/Jan2005/Feb2005/March2005 &
it's displayed on a bar chart. I need to sort/chart by the GREATEST quantity
of the LATEST month. Thanks to all who attempt investigating
this,...Michaelcip
 
...Access2002. I need to sort the field order
of source fields that are dynamic. For e.g.: I
have a chart that displays the last 3 month of a
quantity - every month that passes brings on a
new month & disregards the old. The current
field arrangement is:
Manager/Jan2005/Feb2005/March2005 &
it's displayed on a bar chart. I need to sort/
chart by the GREATEST quantity of the
LATEST month. Thanks to all who attempt
investigating this,...
Click to expand...

Sorry, I don't understand, from this description, what data you have and how
you have it stored, so can only offer a "generic" suggestion:
The order of the information in the Record Source of a Report is
disregarded, and, thus, immaterial. Only the Sorting and Grouping properties
of the Report determine the order in which information is displayed.

A "workaround" is to Sort/Group on a calculated Field in the Query , and
calculate an appropriate sequence of values when the Query is executed.

On the other hand, one could deduce from your description of "field
arrangement" that your field names represent data (the date) and, thus,
violate relational design principles -- if so, that may make it difficult to
accomplish what you want.

Larry Linson
Microsoft Access MVP
 
Back
Top