>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.

If you're using VFP, the simplest way will be to scan the whole table and update this counter in the scan loop.