Hello, I’m trying to do a search form using data from more than one tables in my app. I’would search the data on this condition–> If the project is “e-SicilyTravel BlockChain” and the partner is “Arancia-ICT”, go in table “Dati Personale” and SUM the column “Costo” where “Periodo” is >= than “DA”, <= than “A” and “Partner” is equal to "Arancia-ICT.
I tried whit this formula but It is wrong in the syntax
IF [Progetto]= “e-SicilyTravel BlockChain”,
AND ([Periodo]>=[DA],[Periodo]<=[A], [Partner]= “Arancia-ICT”)
The search form is this one
The main problem is that I have different project and different partner and it means that the formula could be very complicated.
I hope in your support.