sort groups of 2 columns independently from other groups

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

Guest

I have a spreadsheet that is similar to this:

Rep Net% Rep Renewal % Rep # of New Rep $ of New

I would like to generate this in Access, and be able to sort each group
"Rep/Net", "Rep/Renewal", "Rep/#New" in descending order to appear like:

Fred 123 Ann 321 Ted 231
Ann 122 Fred 320 Ann 220
Ted 100 Ted 200 Fred 100

Any help would be greatly appreciated.
 
"dawn" wrote
I have a spreadsheet that is similar to this:

Rep Net% Rep Renewal % Rep # of New Rep $ of New

I would like to generate this in Access, and be able
to sort each group "Rep/Net", "Rep/Renewal",
"Rep/#New" in descending order to appear like:

Fred 123 Ann 321 Ted 231
Ann 122 Fred 320 Ann 220
Ted 100 Ted 200 Fred 100
Click to expand...

Put each list in a narrow Report sorted as you wish, and then put each
narrow Report in a SubReport Control on the main Report, side by side. Be
sure to set the CanGrow property of the Subreport Control to Yes or True.

Larry Linson
Microsoft Access MVP
 
Larry, thank you so much for your response. I finally had time & peace &
quiet to sit down and work on this project again. After I figured out that I
had to start with a blank base report, rather than trying to bring the
sub-reports into one of the existing, it worked great!

I have one more question for you, if you don't mind... What if I have
multiple markets that I want to track in the same database. How do I go
about being able to specifiy the market I want to view, without having to
enter the market code up to 8 times, once for each query I have the
sub-reports based on, in order to generate one report?

Thanks!

dawn
 
o.k. I have tried to set up a form to specify Criteria, but I have run into
some snags:

1) first field that I have will not allow me to set format to text. Example
of Main Criteria is ABC/06.
2) 2nd field: Status W/ Company. For the majority of the reports I will
be pulling, this should <>Termed, but, again, criteria will not be accepted.
I've tried "Is Null" as well, which works in the query, but does not work in
the text. I can play w/ Yes/No, and see how that works (After thought).
3rd - Can't test this one, as nothing else works, but the "# of Weeks in
Canvass" should be <>0, as some reps will be entered into database before
they actuallty have any sales. How do I specify this?

I'm attempting to give as many details as possible, to enable anyone out
there to help me out!

Thanks!

d
 
Back
Top