Capture your entire system, including the host, with patented disk imaging integrated with VMware VADP / Microsoft VSS and RCT. RTOs is as low as 15 seconds with Acronis Active Restore™. You can enjoy unlimited P2V/V2V migrations from any source (even from a different hypervisor)
Course Of The Month
9 days, 9 hours left to enrollBecome a Premium Member and unlock a new, free course in leading technologies each month.
Solved
Proper Dcount Syntax
Posted on 2013-11-13
I have the following rowsource in a list box pulling data to display... which is working:
SELECT Count(*) FROM Tpatient WHERE (((Tpatient.RecallNumber)=
SELECT Count(*) FROM TPatient WHERE (((TPatient.FirstVLetter)=
I would like to change each of these to for use in VBA with a DCount to obtain their value. I am not able to get the syntax correct.
Is this possible and if so what should the proper syntax be for DCount?
SELECT Count(*) FROM Tpatient WHERE (((Tpatient.RecallNumber)=
SELECT Count(*) FROM TPatient WHERE (((TPatient.FirstVLetter)=
I would like to change each of these to for use in VBA with a DCount to obtain their value. I am not able to get the syntax correct.
Is this possible and if so what should the proper syntax be for DCount?
[X]
Welcome to Experts Exchange
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
- Help others & share knowledge
- Earn cash & points
- Learn & ask questions
2 Comments
Active 6 days ago
Syntax for the first case:
Syntax for the second case:
DCount("*", "Tpatient" , "(((Tpatient.RecallNumber)=0) And ((Date()-TPatient!LastApmnt)>(TPatient!RecallFreq*30)) And ((TPatient!RecallActive)=-1)) Or (((Date()-TPatient!RecallNotice)>30) And ((Tpatient.RecallFreq)<12) And ((Tpatient.RecallNumber)<4) And ((Date()-TPatient!LastApmnt)>360) And ((TPatient!RecallActive)=-1)) Or (((Date()-TPatient!RecallNotice)>30) And ((Tpatient.RecallFreq)>=12) And ((Tpatient.RecallNumber)=1) And ((TPatient!RecallActive)=-1))")
Syntax for the second case:
DCount("*", "TPatient", "(((TPatient.FirstVLetter)=0) AND ((TPatient.RecallActive)=-1) AND ((TPatient.Zip) Is Not Null))")
Featured Post
Question has a verified solution.
If you are experiencing a similar issue, please ask a related question
Suggested Solutions
| Title | # Comments | Views | Activity |
|---|---|---|---|
| Omit After Update event | 5 | 40 | |
| ms access - Helpdesk ticket system | 5 | 37 | |
| MS Access Trouble With Grouping and Suming Query Results | 6 | 45 | |
| ISeries Remote Location Route entry | 2 | 18 |
Preparing an email is something we should all take special care with – especially when the email is for somebody you may not know very well. The pressures of everyday working life stacked with a hectic office environment can make this a real challen…
You need to know the location of the Office templates folder, so that when you create new templates, they are saved to that location, and thus are available for selection when creating new documents. The steps to find the Templates folder path are …
Familiarize people with the process of utilizing SQL Server functions from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Ac…
With Microsoft Access, learn how to specify relationships between tables and set various options on the relationship.
Add the tables:
Create the relationship:
Decide if you’re going to set referential integrity:
Decide if you want cascade upda…
Suggested Courses
Course of the Month9 days, 9 hours left to enroll
740 members asked questions and received personalized solutions in the past 7 days.
Join the community of 500,000 technology professionals and ask your questions.