I have a Query that pulls rooms due for inspection, it has 7 fields:
Roomid final inspection 1month schedule inspec 3months schedule inspec 6months schedule inspec 9months and 1year.
The 1,3,6,9 and 1 year field are calculated date fields based on final inspection date. The query works fine but my problem is when I try to pull rooms that due for inspection out of the 1,3,6,9and 1year data based on user input between start and end date nothing comes up. any help is really appreciated.