sort groups of 2 columns independently from other groups

D

dawn

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.
 
L

Larry Linson

"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
 
D

dawn

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
 
D

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
 
Top