Just for now - try this [I changed the Format to "m/dd/yyyy"]:
Code:
SELECT Count ([DataChanges_Part2].[DateAdded]) As TotalRecordsToday
FROM DataChanges_Part2
WHERE (((Format([DataChanges_Part2].[DateAdded],"m/dd/yyyy"))=Date()));
See if that gives you your count.
Then - see if you can remove your 'short date' format in your table - leave it blank - so that it reverts to the default date format [which I think should be mm/dd/yyyy].
You need all your dates to have a standard appearance [ie - 09/09/2011 . . . two digits for month & date & 4 digits for year . . .]
Otherwise that Where clause will not work unless your month is 10 or more and your date is the 10th of the month or more . . . .
Let me know.