Great Catch.
=DCount("ApplicationID","qryWaitingListCurrentMonth"," StatusDate BETWEEN Year(StatusDate) = Year(Date()) AND Month(StatusDate) = Month(Date()) ")
But this express should be returning records in the current month but it is returning 0. I checked the table and there are records in it for August. It should return all the records from the 1st day of the month to the last day of the month.
With warm regards,
Arthur Lorenzini| SQL Server/Access Developer l alorenzin@live.com
Office: 605-338-0947| Mobile: 605-857-9137 | Fax: 605-338-0947
1316 E. 7th Street
Sioux Falls, SD 57103
SQL Server Development
Database Adminstration Services
Microsoft Access Development
Grant Writing TA Services
IT Assessment Services
Software Application Training
From: Duane Hookom <duanehookom@hotmail.com>
To: Access Professionals Yahoo Group <ms_access_professionals@yahoogroups.com>
Sent: Sunday, August 28, 2011 12:23 PM
Subject: RE: [MS_AccessPros] Dcount not working
There is no field [ApplicationStatusTypeID] exposed in the SELECT section of qryWaitingListCurrentMonth. Why is this even included in the DCount() since records in the query are already filtered?Duane HookomMS Access MVPTo: MS_Access_Professionals@yahoogroups.comFrom: dbalorenzini@yahoo.comDate: Sun, 28 Aug 2011 09:50:59 -0700Subject: Re: [MS_AccessPros] Dcount not working =DCount("ApplicationID","qryWaitingListCurrentMonth","ApplicationStatusTypeID =3 AND StatusDate BETWEEN Year(StatusDate) = Year(Date()) AND Month(StatusDate) = Month(Date()) ")THis is what I have now and it's still throwing a error. The is the syntax for qryWaitingListCurrentMonth.SELECT tblApplicationStatus.ApplicantID, tblApplicationStatus.StatusDate, tlkpApplicationStatusType.ApplicationStatusTypeName, tblApplicationStatus.ApplicationIDFROM tblApplicationStatus INNER JOIN tlkpApplicationStatusType ON tblApplicationStatus.ApplicationStatusTypeID =
tlkpApplicationStatusType.ApplicationStatusTypeIDWHERE (((tblApplicationStatus.ApplicationStatusTypeID)=3));With warm regards,Arthur Lorenzini| SQL Server/Access Developer l alorenzin@live.comOffice: 605-338-0947| Mobile: 605-857-9137 | Fax: 605-338-09471316 E. 7th Street Sioux Falls, SD 57103 SQL Server DevelopmentDatabase Adminstration ServicesMicrosoft Access Development Grant Writing TA ServicesIT Assessment ServicesSoftware Application Training From: Crystal <strive4peace2008@yahoo.com>To: MS_Access_Professionals@yahoogroups.comSent: Sunday, August 28, 2011 11:10 AMSubject: Re: [MS_AccessPros] Dcount not working Hi Art,if the data type for ApplicationStatusTypeID is numeric, then remove the delimitersApplicationStatusTypeID = '3' -->ApplicationStatusTypeID = 3Make sure that the DisplayControl for ApplicationStatusTypeID in the table design is TEXTBOX, not combo or listbox~~~if it still doesn't work, change the Between clause to
[Non-text portions of this message have been removed]
Tidak ada komentar:
Posting Komentar