Information générale
Catégorie:
Codage, syntaxe et commandes
Versions des environnements
>>>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.
You're right. I thought he wanted this in a report (no doubt because of the other message).
Tamar
Précédent
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement