Darren DICK
d.dick at uws.edu.au
Tue May 11 22:56:27 CDT 2004
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