Is it possible to get a report where every column is sorted the way I want it?

[PeterGundrum]

Or a form?

Is there some way I can get a report where if I have 6 or 7
columns and I want to sort them different ways?


Do I have to use subreports or forms or what?


I hope you understand what I mean. Any help would be
appreciated.

 

[Rick B]

Typically, each line is a record where the first column might be the name,
second might be the address, etc. If you 'sort' them diffferently, then the
report would make no sense. If the first line contains Bob's name, then
address, then phone number, then birthdate, you would not want to move his
birthdate to another line by sorting that column.

If you want to sort the entire report based on mutliple columns (fields or
controls) then you would jsut put multiple items in your sort/group box. In
the above example, if you have two lines with the name "Bob" you can
certainly use the address as your second sort criteria. But, the entire
line is moved up or down.

You might want to post more details on what your database structure is.

Rick B

 

[Guest]

Let's just say for example that I am a teacher and I have a
database with all my student's records in it.

So I do a query and find all the records for the students I
am looking at. Now I want to make a report for this query.

But for this report I want to group by name and have each
student's records underneath their name but I also want to
have 2 columns sorted in a certain way. Maybe I want the
field "test scores" sorted descending and I have another
field called "letter grades" that I want to sort ascending.


I don't want to change their records in any way and I don't
want to break their records up. On a report only, I would
like to see these 2 columns sorted the way I mentioned above.

I this possible somehow? Or do I have to use a form or
something else.

 

[Rick B]

How can you sort the score descending and the letter ascending?

Next to a grade of 50, you will have an "F". Next to a grade of 95, you
will have an "A". The sort on the second column is not relavent. You would
sort by the grade, and the letter associated with each grade would follow.
You don't need to tell it how to sort the letters. They are part of the
same record. A 95 will always have an A next to it.

Have you tried to create this yet so you can see how it works?

Create your query to pull all the names and grades. Tie that query to a
report. Group/Sort by name first and include a group header. Then as your
second sort use the number grade.

In your Name Group Header, pull the student name fields.

In the detail section of the report, pull the number grade, and the
associated letter grade.

Run the report.


Rick B

 

[Guest]

You're not understanding what I am asking for. I'll use a
different field other than "letter grades"

I am just wondering if it is possible to group my students
by name and then look at two fields sorted differently,
Maybe "test scores" sorted descending. And another maybe
"hours spent in study hall" sorted ascending.

The fields don't have to be related the way test score and
letter grades were. I'm just trying to find out if you can
look at the results of a query this way. Is there some way
to do it?

 

[Rick B]

Yes and No.

In the query, you would have name, test score, hours in study hall. Since the name is in column 1, the entries in column 2 and 3 must stay with the name.

You could create TWO queries and do this. One would show Name and Score (sorted by score). The second would contain Name and Hours (sorted by hours).

There is no way (and logically there would not be) to sort columns 2 and 3 differently if the key (name) is in column 1.

Please post an example of what you'd want to see. Give us details like I did in my posts. Tell us a few names, the corresponding numbers, and then type out the data the way you think it should look on the report or screen.

Do you have a current report (that you make with paper and pencil) that does this? I just can't imagine how you could sort the columns independant of the key field and have the report make any sense.

Give us a picture of your data.

Rick B





The only example I could come up with is....


John Smith
Test Scores Quiz Scores
11/14/04 95 11/09/04 100
11/07/04 90 11/02/04 88
11/21/04 81 11/16/04 80

Susan Jones
Test Scores Quiz Scores
11/21/04 98 11/02/04 90
11/07/04 92 11/16/04 87
11/14/04 88 11/09/04 84


Notice each "subreport" is sorted by number.



If that is what you want, then you would need to create two sub reports (one for Test and one for Quiz) and then place them in a main report side-by-side in the detail section.


Rick B

 

[Peter Gundrum]

Rick B, sorry for the delay responding. Your example
given below is EXACTLY what I am looking for. I had a
feeling I would have to create subreports but I wasn't
sure how to do it. So they have to be placed in the
detail section?

BTW, the reason for this is that I will be able to
evaluate each student without having to run a new query
each time that I want to look at a different field sorted.
Using your example, I will be able to see the high scores
for both "test scores" and "quiz scores" at the same
time. Or the low scores. I also won't have to print out
a new report every time I sort by a different column if I
wanted a hard copy of the query.

Thanks very much for your help Rick.

-----Original Message-----
Yes and No.

In the query, you would have name, test score, hours in

study hall. Since the name is in column 1, the entries in
column 2 and 3 must stay with the name.

You could create TWO queries and do this. One would show

Name and Score (sorted by score). The second would
contain Name and Hours (sorted by hours).

There is no way (and logically there would not be) to

sort columns 2 and 3 differently if the key (name) is in
column 1.

Please post an example of what you'd want to see. Give

us details like I did in my posts. Tell us a few names,
the corresponding numbers, and then type out the data the
way you think it should look on the report or screen.

Do you have a current report (that you make with paper

and pencil) that does this? I just can't imagine how you
could sort the columns independant of the key field and
have the report make any sense.

Give us a picture of your data.

Rick B





The only example I could come up with is....


John Smith
Test Scores Quiz Scores
11/14/04 95 11/09/04 100
11/07/04 90 11/02/04 88
11/21/04 81 11/16/04 80

Susan Jones
Test Scores Quiz Scores
11/21/04 98 11/02/04 90
11/07/04 92 11/16/04 87
11/14/04 88 11/09/04 84


Notice each "subreport" is sorted by number.



If that is what you want, then you would need to create

two sub reports (one for Test and one for Quiz) and then
place them in a main report side-by-side in the detail
section.