Select Distinct with criteria in subform after filtred (1 Viewer)

Joaofigu

Registered User.
Local time
Today, 08:35
Joined
Apr 12, 2019
Messages
12
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
 

theDBguy

I’m here to help
Staff member
Local time
Today, 08:35
Joined
Oct 29, 2018
Messages
21,358
Hi. Welcome to the forum. I’m afraid I don’t understand your question. Are you able to post a sample copy of your db with test data?
 

Users who are viewing this thread

Top Bottom