I am trying to break down records in an unbound report, by year.
The table (tblIssues) contains approx. 5 years of data.
The date field is Date_Time
Whenever I attempt to add a date filter to a DCOUNT statement, it returns a value of '-1'.
Without the date filter, the DCOUNT statemtent returns all records.
Can anyone debug the following statement and let me know why it's blowing up (it's for this year's records)?
=DCount "Standard_Issues","tblIssues","Standard_Issues='Amendment Questions'"
And ("[Date_Time]","tblIssues","[Date_Time] Between Format('1/1/' & Year(Now),'m/d/yyyy') And Now"
Possibly even point me in the direction of how to properly filter a date. I've looked through all of the DCOUNT posts on Tek Tips, but am having quite a bit of trouble applying it to my report.
Any help is greatly appreciated.
Willy
The table (tblIssues) contains approx. 5 years of data.
The date field is Date_Time
Whenever I attempt to add a date filter to a DCOUNT statement, it returns a value of '-1'.
Without the date filter, the DCOUNT statemtent returns all records.
Can anyone debug the following statement and let me know why it's blowing up (it's for this year's records)?
=DCount "Standard_Issues","tblIssues","Standard_Issues='Amendment Questions'"
Possibly even point me in the direction of how to properly filter a date. I've looked through all of the DCOUNT posts on Tek Tips, but am having quite a bit of trouble applying it to my report.
Any help is greatly appreciated.
Willy