ACCESS FEED: Re: [MS_AccessPros] Dcount not working

Minggu, 28 Agustus 2011

Re: [MS_AccessPros] Dcount not working

Hi Art,

if the data type for ApplicationStatusTypeID is numeric, then remove the delimiters

ApplicationStatusTypeID = '3' -->
ApplicationStatusTypeID = 3

Make 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 -->

Year(StatusDate) = Year(Date()) AND Month(StatusDate) = Month(Date())

Warm Regards,
Crystal

Access Basics by Crystal (Bill Mosca's site)
http://thatlldoit.com
Free 100-page book that covers essentials in Access

*
(: have an awesome day :)
*

--- On Sun, 8/28/11, Art wrote:

> I have the followin expression that
> uses a dcount function:
>
> =DCount("ApplicantID","qryWaitingListCurrentMonth","ApplicationStatusTypeID
> = '3' AND StatusDate BETWEEN
> DateSerial(Year(Date()),Month(Date()),1) and
> DateSerial(Year(Date()),Month(Date())+1,0)")
>
> It is returning a error.
>
> I think it has to do with this part:
>
> ApplicationStatusTypeID = '3'
>
> Can you give me some advice?
>
> Thanks,
>
> Art Lorenzini
> Sioux Falls, SD
>