Grouping Problems....

[vbjohn]

I have this big query that I am using in the Visual Basic program. I need to group togther "CHEKNMBR".


The problem is that the "CHEKNMBR" needs to be grouped by... Regular Checks and Direct Depoist Checks.

Regular Checks always start with "79------"
and
Direct Deposites always start with "DD-------"

Is there any way that I can do this?

...Please Help...

 

[rac2]

If sorting is the problem then this will do it -

SELECT cheknumbr
ORDER BY SUBSTRING(cheknumbr, 1, 2)

If labels are needed add this -

SELECT
   CASE SUBSTRING(cheknumbr, 1, 2)
      WHEN '79' THEN 'Regular Check'
      WHEN 'DD' THEN 'Direct Deposit'
      ELSE 'Other'
   END AS "Type of Deposit",
   cheknumbr

If subtotals are needed then -

SELECT SUBSTRING(cheknumbr, 1, 2), SUM(amount_of_deposit)
GROUP BY SUBSTRING(cheknumbr, 1, 2)