Help with Dcount

[tozey]

Hi Guys, excellent forum.



I need a little Dcount.

I have got so far but am stuck, I need to include a date difference number to identify my cases.

Here is how I have written it


Dim PRIORITY$
PRIORITY = "06/08/2010"

Result = DCount("[AccountNumber]", "Main Table", "[CampaignTitle] = 'Mission' and [CurrentStatus] not like 'Unallocated' and [LoadedDate] < #" & PRIORITY & "# and [DateInitiallyWorked] - [LoadedDate] > 7 ")

I have tried many combinations from but just cannot get it.

hope you can help?

Thanks for your help in advance, it is very much appreciated.

Alex

[pbaldy]

Two thoughts right off. Due to the inadvisable space, the table name may need to be bracketed. Second, if you meant that date to be August 6, Access is probably interpreting it as June 8.