Hi All,
Working on an audit database, I have a table 'Sheet2' with the columns [Receive Date], [Case No] (PK), and [Date Report Updated]. I have set a form for the user to enter the 'Start' and 'End' parameters on [Receive Date], and have an expression in the query to calculate the Total time of the Case- TotalTime: DateDiff('d',[Receive Date],[Date Report Updated]).
What I am failing miserably in doing is trying to develop expressions to calculate;
a count of the number of Case No's in which the TotalTime is <5 days
a count of the number of Case No's in which the TotalTime is <7 days
....within the duration specified by the 'Start' and 'End' parameters of the receive date.
Trying all sorts but no joy. Basic SQL reads;
Code:
SELECT Sheet2.[Receive Date], Sheet2.[Case No], Sheet2.[Date Report Updated], Sheet2.[Date Report Status1 Achieved], DateDiff('d',[Receive Date],[Date Report Updated]) AS TotalTime
FROM Sheet2
WHERE (((Sheet2.[Receive Date]) Between [Forms]![Audit]![Start] And [Forms]![Audit]![End]));
Is this possible? Any info gratefully received.
Mattbro