Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

dcount with date not working 1

Status
Not open for further replies.
dinster

dinster

Programmer
Apr 12, 2007
54
GB
Hi all,

Am trying to use this code in the control source of a textbox and i get an error msg. Am not sure where i gone wrong :s

Code: 
=DCount("[ID]","sheet4","dateadded BETWEEN #" & 1/11/2007 & "# AND #" & 30/11/2007 & "#")

many thanks
 
Sort by date Sort by votes
You dates are not variables, so they need to be inside the quotes. You must use unambiguous dates, and the easiest way to do this is to use yyyy/mm/dd, so:

[tt]=DCount("[ID]","sheet4","dateadded BETWEEN #2007/11/01# AND #2007/11/30#")[/tt]
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

Moss100
  • Locked
  • Question
Code not working 1
Replies
5
Views
216
Darrylles
Darrylles
Moss100
  • Locked
  • Question
Find unique rent amount and date this was first charged
Replies
4
Views
496
dhookom
dhookom
Moss100
  • Locked
  • Question
Vba filter not working 3
Replies
7
Views
308
Cole Mendoza
Cole Mendoza
Drago1920
  • Locked
  • Question
Finding the lowest date
Replies
2
Views
318
Andrzejek
Andrzejek
M
  • Locked
  • Question
display a calendar with appointments in body of html email with access vba
Replies
1
Views
2K
SoftwareRT
SoftwareRT

Part and Inventory Search

Sponsor

Back
Top