Sort/Group Question

[Imconfused]

I need to perform a sort within my query or create a sub query that performs the needed function. Within a particular field, each record contains a 5 digit numeric value. I need to sort/group this field based on the last digit of the numeric value of each record. I feel like I may need to create sub-queries that will perform this function based on each specific numeric value (last digit) which it may be any number from 1 to 7 (therefore creating 7 sub-queries).
1. How do I sort/group based on the last digit?
2. Are sub-queries the best way of maintaining separate groupings (these will be used to produce reports based on the groupings)?

 

[lespaul]

Try something like this:

SELECT RIGHT(FIELDNAME, 1) FROM TABLENAME GROUP BY RIGHT(FIELDNAME, 1)

 

[Imconfused]

Les,

I'm not sure I understand. Is this an expression?

 

[GoDawgs]

Add a new field that looks like this:

TheNumber: right([fieldname],1)

That will give you the last digit on its own and allow you to sort by that if that's what you mean. If you need totals by this digit then you can make it a summary query and group by this field too. Explain your situation a little more if you're still confused.

Kevin

 

[Imconfused]

Hence, my name: I'm Confused

But it worked just fine, thanks for the help, this is a lot better than trying to figure it out by reading "Access For Dummies".