[AccessD] A2K: Can't Get DCount to work

Hi Andy
Thanks for the response
Yep that's what I actually put in place.
Thanks to Stephen -
Yes I will SYWYE
DD

----- Original Message ----- 
From: "Andy Lacey" <andy at minstersystems.co.uk>
To: "'Access Developers discussion and problem solving'" <accessd at databaseadvisors.com>
Sent: Wednesday, May 12, 2004 5:02 PM
Subject: RE: [AccessD] A2K: Can't Get DCount to work


> Hi Darren
> 
> I think you need both of Stephen's suggestions. Try this:
> 
> intX = DCount("[OffenceDate]", "tblOffences", "[OffenceDate] = #" &
> Format(Me!txtOffenceDate,"mm/dd/yy") & "#")
> 
> Have a great day.
> SYWWE
> 
> -- Andy Lacey
> http://www.minstersystems.co.uk 
> 
> > -----Original Message-----
> > From: accessd-bounces at databaseadvisors.com 
> > [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Darren DICK
> > Sent: 12 May 2004 06:07
> > To: Access Developers discussion and problem solving
> > Subject: Re: [AccessD] A2K: Can't Get DCount to work
> > 
> > 
> > Thanks for the reply Stephen
> > No joy on the Hash character :-((
> > 
> > The date format doesn't change it either
> > 
> > <sigh>
> > 
> > ----- Original Message ----- 
> > From: "Stephen Bond" <stephen at bondsoftware.co.nz>
> > To: "Access Developers discussion and problem solving" 
> > <accessd at databaseadvisors.com>
> > Sent: Wednesday, May 12, 2004 2:58 PM
> > Subject: RE: [AccessD] A2K: Can't Get DCount to work
> > 
> > 
> > > 1.  Surround the date with the hash sign (#).
> > >     so, "[OffenceDate] = #" & Me!txtOffenceDate) & "#"
> > > 2.  The other thing that comes to mind, and this 
> > >     is off the top of my head, is that some expressions
> > >     require dates to be in US format, so you may have
> > >     to do this to Format(Me!txtOffenceDate),"mm/dd/yyyy")
> > > 
> > >     This might apply to SQL sattements only, can't remember
> > > 
> > > Stephen Bond
> > > NZ
> > > 
> > > > -----Original Message-----
> > > > From: Darren DICK [mailto:d.dick at uws.edu.au]
> > > > Sent: Wednesday, 12 May 2004 3:56 p.m.
> > > > To: AccessD List
> > > > Subject: [AccessD] A2K: Can't Get DCount to work
> > > > 
> > > > 
> > > > Hello all
> > > > Can anyone tell me what I am doing wrong here?
> > > > I am trying to use dcount to determine how many occurrence of
> > > > a particular date appear in a table
> > > > In my test table there are 8 records with the date 11/05/2004 
> > > > So... In my code below,  Msgbox intX should show 8 but it 
> > > > keeps showing 0 (Zero)
> > > > 
> > > > Dim intX As integer
> > > > intX = DCount("[OffenceDate]", "tblOffences", "[OffenceDate]
> > > > = " & Me!txtOffenceDate)
> > > > MsgBox intX
> > > > 
> > > > The table tblOffences is an existing table
> > > > the field OffenceDate is an existing field Data
> > > > Type:Date/Time  formatted dd/mm/yyyy
> > > > The control on my form txtOffenceDate is an existing control 
> > > > (formatted dd/mm/yyyy)
> > > > 
> > > > I have checked spelling of field names many times and have
> > > > even copied and pasted
> > > > the field names to guarantee spelling.
> > > > 
> > > > I have turned 'on and off' the formatting in various combinations.
> > > > 
> > > > Just can't get it to work
> > > > 
> > > > Any suggestions?
> > > > 
> > > > Many thanks
> > > > 
> > > > Darren
> > > > 
> > > > --
> > > > _______________________________________________
> > > > AccessD mailing list
> > > > AccessD at databaseadvisors.com
> > > > http://databaseadvisors.com/mailman/listinfo/accessd
> > > > Website: http://www.databaseadvisors.com
> > > > 
> > > --
> > > _______________________________________________
> > > AccessD mailing list
> > > AccessD at databaseadvisors.com
> > > http://databaseadvisors.com/mailman/listinfo/accessd
> > > Website: http://www.databaseadvisors.com
> > -- 
> > _______________________________________________
> > AccessD mailing list
> > AccessD at databaseadvisors.com 
> > http://databaseadvisors.com/mailman/listinfo/a> ccessd
> > Website: 
> > http://www.databaseadvisors.com
> > 
> > 
> 
> -- 
> _______________________________________________
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com