Sorting & Grouping Problem

  • Thread starter Thread starter Texernie1
  • Start date Start date
T

Texernie1

I am having a problem with a report in MS Access 2002. It is based on a table
with the fields Order, Temp, Identifier, & Data.

Order is a number indicating the order of that line of data in the report
(Ascending). My report shows Temp, Identifier, and Data in that order from
L-to-R.

The Sorting and Grouping table is
(No Header/Footer) Order, Ascending
(Header/Footer) Temp, Ascending

In the sorting and Grouping box, if I put Order first, in ascending order, I
get the right order, but it repeats Temp and the Temp header/Footer on every
line.

If I move Order below Temp in the in the Sorting and Grouping box, I get the
right grouping (only 1 temp displayed), but the order is wrong.

If I move the Order to the report's OrderBy property, it has no effect.

What am I doing wrong?

Thanks in advance for your help.

Regards,
Keith
 
If I recall, in that version of Access it doesn't matter what Order By you
might be using in a query, the report itself needs the Sorting/Grouping set.

If you have sections of your report that repeat, perhaps you have the
sections (not the Sort/Group) turned around.

It all starts with the data! Is there a relationship among the fields in
your table?

I'm not clear on how you are using "Order" to get a "L-to-R" sequencing.

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
Jeff,

Thanks for the response.

The Order field describes the order of the data from top to bottom. The
three displayed fields are Temp, Identifier, and Data from Left to Right on
the report.

The data in the table is created by a macro, which is an iterative summary
of the relationship between two much larger tables.

Sample data:
Order, Temp, Identifier, & Data
1,25C,A,xxxx
2,25C,B,xxxx
3,25C,C,xxxx
4,50C,A,xxxx
5,50C,B,xxxx
6,50C,C,xxxx

What I want from this is:
25C A xxxx
B xxxx
C xxxx
50C A xxxx
B xxxx
C xxxx


What I get is either

25C A xxxx
25C B xxxx
25C C xxxx
50C A xxxx
50C B xxxx
50C C xxxx

or I get

50C A xxxx
B xxxx
C xxxx
25C A xxxx
B xxxx
C xxxx

Hope this helps.
Regards,
Keith
 
Based on the output you described in your example, I would group by Temp and
show Temp by itself in a group header, then show Identifier and Data fields
in the Details section "beneath" the Temp group header. I'd sort by
Identifier, then Data.

I suppose another way to do this is to sort by Temp and show Temp,
Identifier & Data fields in a Details section, but change the property of
the Temp control to hide duplicates.

NOTE: this is untested

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
Jeff,

I think I had tried that and it didn't work.

I did get my probelm solved. I recreated the report using a tabular
layout then had the Temp field hide duplicates. I got a line to show between
groups by using the OnFormat event of the data section to either hide or
display a line in the data section.

Thanks for the help and suggestions.
Keith
 
Back
Top