Here is the SQL code:
SELECT [IBCCP Referral].[Caller ID], DCount("[Caller ID]","IBCCP
Referral","[Caller ID] <= " & [Caller ID]) Mod 10 AS Expr1, [IBCCP
Referral].CallDate, [IBCCP Referral].CallTaker, [IBCCP
Referral].ProviderNameNumber, [IBCCP Referral].HowHear, [IBCCP
Referral].[IRIS Referral Number], [IBCCP Referral]![First Name] & " "
& [IBCCP Referral]![Middle Initial] & " " & [IBCCP Referral]![Last
Name] AS FullName, [IBCCP Referral].LanguagePreferenceID, [IBCCP
Referral].Age, [IBCCP Referral].HomePhone, [IBCCP Referral].WorkPhone,
[IBCCP Referral].CellPhone, [IBCCP Referral].Address, [IBCCP
Referral].City, [IBCCP Referral].Zip, [IBCCP Referral].[County Code
ID], [IBCCP Agencies].Name, [IBCCP Referral].RoutineScreening, [IBCCP
Referral].Comments, [IBCCP Referral].QualityAssuarnce
FROM [IBCCP Referral] INNER JOIN [IBCCP Agencies] ON [IBCCP
Referral].AgencyID = [IBCCP Agencies].ID
GROUP BY [IBCCP Referral].[Caller ID], DCount("[Caller ID]","IBCCP
Referral","[Caller ID] <= " & [Caller ID]) Mod 10, [IBCCP
Referral].CallDate, [IBCCP Referral].CallTaker, [IBCCP
Referral].ProviderNameNumber, [IBCCP Referral].HowHear, [IBCCP
Referral].[IRIS Referral Number], [IBCCP Referral]![First Name] & " "
& [IBCCP Referral]![Middle Initial] & " " & [IBCCP Referral]![Last
Name], [IBCCP Referral].LanguagePreferenceID, [IBCCP Referral].Age,
[IBCCP Referral].HomePhone, [IBCCP Referral].WorkPhone, [IBCCP
Referral].CellPhone, [IBCCP Referral].Address, [IBCCP Referral].City,
[IBCCP Referral].Zip, [IBCCP Referral].[County Code ID], [IBCCP
Agencies].Name, [IBCCP Referral].RoutineScreening, [IBCCP
Referral].Comments, [IBCCP Referral].QualityAssuarnce
HAVING (((DCount("[Caller ID]","IBCCP Referral","[Caller ID] <= " &
[Caller ID]) Mod 10)=0) AND (([IBCCP Referral].CallDate) Between
[Forms]![frmIBCCPLabelsRe****ts]![txtQAStart] And [Forms]!
[frmIBCCPLabelsRe****ts]![txtQAStop]) AND (([IBCCP
Referral].QualityAssuarnce)=False))
ORDER BY [IBCCP Referral].[Caller ID];
I just do not get why the field, CallDate or rather query does not
return any records? The criteria for field, CallDate, in the above
query is:
Between [Forms]![frmIBCCPLabelsRe****ts]![txtQAStart] And [Forms]!
[frmIBCCPLabelsRe****ts]![txtQAStop]
Thanks,
Zufie


|