[MS_AccessPros] Count of Values for One Field Within Another

 

I need help in either query builder syntax of SQL syntax to count values for one field within another.
I have a table with a column called SvcBlock (Length of 5, numeric)
SvcBlock is parsed into two columns:
SvcRte (Left (SvcBlock,3)) and SvcRun (Right (SvcBlock,2))
09701
09702
09801
10001
10002
10003
10104
I need a query that will return the count of SvcRun within SvcBlock
From the data example above, the result set I need would be:
097 2
100 3
101 1

__._,_.___

Reply to sender | Reply to group | Reply via web post | Start a New Topic

Messages in this topic (1)

Recent Activity:

• New Members 10
• New Files 1

Visit Your Group

MARKETPLACE

A bad score is 598. A bad idea is not checking yours, at freecreditscore.com.

---

Stay on top of your group activity without leaving the page you're on - Get the Yahoo! Toolbar now.

Switch to: Text-Only, Daily Digest • Unsubscribe • Terms of Use

.

__,_._,___