>Hi All,
>
>May I know how to use the sql to count a record by grouping.
>example:
>
>Table A
>======
>Receipt DiscountDesc DiscountAmt
>1000 10% discount 10
>1000 20% discount 20
>1001 10% discount 10
>1002 50% discount 50
>1002 10% dsicount 10
>
>
>How to include the running number /counter in record by receipt group such as the output is:
>
>Receipt DiscountDesc DiscountAmt Counter
>1000 10% discount 10 1
>1000 20% discount 20 2
>1001 10% discount 10 1
>1002 50% discount 50 1
>1002 10% dsicount 10 2
>
>Thanks for your help in advance.

Take a look at the message I just posted in the Report Designer section in the thread "Variable to count distinct number." What you need is a variation on what that poster needs. You use the same basic strategy, but change what you're counting.

Tamar