Hi,
The query statement below is meant to extract the number of References with a type code of 'M' on the table tblHDRef, then present it under a column named 'Modified':

Modified: DCount("[tblHDRef].[HD Ref]","[tblHDRef]","[tblHDRef].[HD CodeType]='M'")

This works fine - but how can I add further criteria to this query statement to only count references with a HD Date greater than 03/02/2008?

I tried:
Modified: DCount("[tblHDRef].[HD Ref]","[tblHDRef]","[tblHDRef].[HD CodeType]='M' and [tblHDRef].[HD Date]>#03/02/2008#")

but this didn't seem to work at all. Am I missing something?

Cheers in advance.

you need to substitute the actual date value .

DCount("[tblHDRef].[HD Ref]","[tblHDRef]","[tblHDRef].[HD CodeType]='M' and [tblHDRef].[HD Date]> " & #03/02/2008#)

Thanks, but the change to the code returns the total number of References with a type code of 'M' for all dates, not the ones with a date stamp of 04/02/2008 or greater ...

Now seems ok. The issue appears to be as it's using American dates on my UK machine. Is there a localisation setting that needs changing in Access to correct this?

What I have found is that when comparing dates in sql always convert the date to US format

FORMAT(MyDate,"mm/dd/yyyy")