Hi,
I have form with filters, and a subform where is the data, and when i apply the filters i want to know for example , Distinct Field A where condition is in field B, and also sum field C.
Example:
i want no count 1 "Remessa", where is familia to count how much Bilhetica and and how much Novos Materiais, and also Sum all where is QDE
can anybody help me, i ´m tryng do read foruns and could not find any like this:
StrSql = Selecte distinct REMESSA where mySUBFORMfiltred
thanks
I have form with filters, and a subform where is the data, and when i apply the filters i want to know for example , Distinct Field A where condition is in field B, and also sum field C.
Example:
i want no count 1 "Remessa", where is familia to count how much Bilhetica and and how much Novos Materiais, and also Sum all where is QDE
can anybody help me, i ´m tryng do read foruns and could not find any like this:
StrSql = Selecte distinct REMESSA where mySUBFORMfiltred
thanks