P
pnn
I am trying to select a distinct records from an access db within a certain
date range.
This is my query:
SELECT DISTINCTROW [Patient Information].[Patient First Name], [Patient
Information].[Patient Last Name], [Patient Information].[Cardiac Rehab
Program ID], First([Patient Sign In].[Date]) AS [First Of Date], Count(*) AS
[Count Of Patient Sign In], [Patient Information].[Notes]
FROM [Patient Information] INNER JOIN [Patient Sign In] ON [Patient
Information].[Cardiac Rehab ID]=[Patient Sign In].[Cardiac Rehab ID]
GROUP BY [Patient Information].[Patient First Name], [Patient
Information].[Patient Last Name], [Patient Information].[Cardiac Rehab
Program ID], [Patient Information].[Notes]
HAVING (((First([Patient Sign In].Date)) between [Type The Beginning Date:]
and [Type The Ending Date:]));
When I specify the date range of 1/10/05 to 1/12/05 I only get records from
1/10 and 1/11 even though there are records for 1/12.
Please advise what is wrong???? Thank you very much
date range.
This is my query:
SELECT DISTINCTROW [Patient Information].[Patient First Name], [Patient
Information].[Patient Last Name], [Patient Information].[Cardiac Rehab
Program ID], First([Patient Sign In].[Date]) AS [First Of Date], Count(*) AS
[Count Of Patient Sign In], [Patient Information].[Notes]
FROM [Patient Information] INNER JOIN [Patient Sign In] ON [Patient
Information].[Cardiac Rehab ID]=[Patient Sign In].[Cardiac Rehab ID]
GROUP BY [Patient Information].[Patient First Name], [Patient
Information].[Patient Last Name], [Patient Information].[Cardiac Rehab
Program ID], [Patient Information].[Notes]
HAVING (((First([Patient Sign In].Date)) between [Type The Beginning Date:]
and [Type The Ending Date:]));
When I specify the date range of 1/10/05 to 1/12/05 I only get records from
1/10 and 1/11 even though there are records for 1/12.
Please advise what is wrong???? Thank you very much