Forum Discussion
count rows with 2 tables
Hi there, I have 2 tables: TblUnits UnitID BusinessUnitID BuildingID UnitStatusID UnitCode UnitShortName UnitTypeID ExploitationDateFrom ExploitationD...
In that case, you can add a condition in the calculation of _unit to take into consideration the dates similar to what you have done above.
See if that works for you
Thanks. I have found the solution for this problem whit help from this community.