Separating "a" from "A" in a query

[David Clifford]

Hello

I'm sure that this has been asked and answered before. I have a table with a
set of graded performance results running from a to E, so, my grade could
be: a, A, b, B, c, C d, D, e, E. The small letter indicates a grade below
the median, and the capital letter indicates a grade above the median. All
works well until I want to see, for example, how many "a" results there are,
and how many "A" results there are.

Using Criteria = "a" in the query gives me the aggregate group "a" + "A".
How can I split up theses two groups? Is there an ASCII function that I can
specify in the Criteria section of the query window?

Sorry if this question has an obvious answer, but I can't find it.

Access 2000, Windows 2000 Professional.

Thank you for your time

Best regards.

David Clifford

 

[Guest]

Add a column in your query AscGrade: Asc(Grade)
This will produce 97 for a and 65 for A which you can then differentiate
between.

 

[RoyVidar]

Hello

I'm sure that this has been asked and answered before. I have a table with a
set of graded performance results running from a to E, so, my grade could
be: a, A, b, B, c, C d, D, e, E. The small letter indicates a grade below
the median, and the capital letter indicates a grade above the median. All
works well until I want to see, for example, how many "a" results there are,
and how many "A" results there are.

Using Criteria = "a" in the query gives me the aggregate group "a" + "A".
How can I split up theses two groups? Is there an ASCII function that I can
specify in the Criteria section of the query window?

Sorry if this question has an obvious answer, but I can't find it.

Access 2000, Windows 2000 Professional.

Thank you for your time

Best regards.

David Clifford

I think Access is designed to be not case sensitive, so you'll probably
create some fun debugging and getting this the way you want, but I
think
a start could be looking into the Asc function:
To get individual marks (a), try:

where asc(myfield) = asc("a")

or (starting the sorting fun;-)

order by asc(myfield)

 

[David Clifford]

Yep..that does it...thank you Dennis.

Best regards

David Clifford