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

The main thing is, that it's very hard to get in the select statement in VFP8. Easier in VFP9 with projection.