I have a date (Actual Discharge Date) and I need to calculate this date + 90days. I have acheived this using DateAdd("d",+90,[ActualDischargeDate])
I need to however run a parameter on this newly calculated cell. I need to see how many records reach thier 90day date within a reporting period.
I have many parameters within my database, but when i enter:
Between [Reporting Period Start Date] And [Reporting Period End Date, the query just retuns all the records, no criteria seems to have been applied.
I've searched the web, high and low, but cannot find an ansewer i understand, as i do not use the SQL side of queries, just the handy to use sections.
Any simple help please?
l3111, Manchester, UK