Hi
I want to build a pass through query for a large query I need to run. I understand how to do it except for 2 things:
1. In the query I have a calculated field which basically works out from 2 dates, which is the most recent and returns the values based on that. So for example:
iif(isnull([modified]),[created],iif([modified]>=[created],[modified],[created])
2. The query runs from a form where the user inputs 2 dates. The calculated field above refers to the date range returned by the form, so, for example, in the criteria of the field above, it says something like:
Between [forms......]StartDate and [forms......]EndDate
Can I build this into the Pass Through query in any way? Thanks
I want to build a pass through query for a large query I need to run. I understand how to do it except for 2 things:
1. In the query I have a calculated field which basically works out from 2 dates, which is the most recent and returns the values based on that. So for example:
iif(isnull([modified]),[created],iif([modified]>=[created],[modified],[created])
2. The query runs from a form where the user inputs 2 dates. The calculated field above refers to the date range returned by the form, so, for example, in the criteria of the field above, it says something like:
Between [forms......]StartDate and [forms......]EndDate
Can I build this into the Pass Through query in any way? Thanks