I'm trying to find the # of days between 2 dates. I built a query with an iif statement to create the start and end dates according to dates that are in the original table - if the start date is before or equal to 7/27/13, make the date 7/27/13, if not, keep the start date as is. Same concept for the end date.
I am not trying to build a query that will look at the dates in the query created above and subtract start date from end date: ActiveMonths: ([qryActiveECNsBiomed]![EndDate]-[qryActiveECNsBiomed]![StartDate])
Every line comes back as #Error. My first thought was that I can't perform a calculation on calculated fields so I made the first query above, a make table query so I could query off of the table. It didn't help.
Any ideas?