Talk About Network

Google


Register and Login
Nick
Password
Register create new account Sign up is FREE and you can post replies, new topics, bookmark posts and more!
Recover lost password


Data Bases > Microsoft Access > CallDate in que...
Latest [ Topics | Posts ] Archive Post A New Topic Post a Reply
<< Topic < Post Post 1 of 2 Topic 29959 of 31576
Post > Topic >>

CallDate in query

by zufie <john.marruffo@[EMAIL PROTECTED] > Apr 14, 2008 at 12:53 PM

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
 




 2 Posts in Topic:
CallDate in query
zufie <john.marruffo@[  2008-04-14 12:53:32 
Re: CallDate in query
Salad <oil@[EMAIL PROT  2008-04-14 14:24:27 

Post A Reply:
  Go here to Signup

AddThis Feed Button


About - Advertising - Contact - Frequently Asked Questions - Privacy Policy - Terms of Use - Signup

Contact
tan12V112 Wed Dec 3 1:46:46 CST 2008.