Hi.
I have a query based on 2 tables. Table 1: IDProject; Table2: IDProjectInfo, fkProject, fkTask, TaskDate. Left join on table 1 IDProject.
I want to use a date range parameter based on a form with user providing the start and end dates: Between [Forms]![f_Basic]![StartDate] And [Forms]![f_Basic]![EndDate]
Wish: if no date range match table 1 IDProject, then return 0
Any thoughts?
I have a query based on 2 tables. Table 1: IDProject; Table2: IDProjectInfo, fkProject, fkTask, TaskDate. Left join on table 1 IDProject.
I want to use a date range parameter based on a form with user providing the start and end dates: Between [Forms]![f_Basic]![StartDate] And [Forms]![f_Basic]![EndDate]
Wish: if no date range match table 1 IDProject, then return 0
Any thoughts?