Hi all. I am trying to solve the following problem. I have 2 tables - tblObjects and tblInspections. When I build query with that 2 tables
I want to create a criterion that allows me to filter for each type of object how many times in the quarter there are inspections - for each quarter (from 01.01. to 31.03.; from 01.04. to 30.06.; from 01.07. to 30.09. from 01.10. to 31.12.). Then to use the form fmFilter and when I set a year for example 2022 it shows me the corresponding frequency of inspections (1, 2, 3, n .... times a year)for each object
I want to create a criterion that allows me to filter for each type of object how many times in the quarter there are inspections - for each quarter (from 01.01. to 31.03.; from 01.04. to 30.06.; from 01.07. to 30.09. from 01.10. to 31.12.). Then to use the form fmFilter and when I set a year for example 2022 it shows me the corresponding frequency of inspections (1, 2, 3, n .... times a year)for each object