Unanswered: Count Automatically Scheduled Appointments by Current Date
How can I display automatically a count of the appointments that are scheduled by the current date? I am doing the following, but it doesn't work: =Count([Date])=Date(), and I have also tried: =DCount("[Date]","Exampletestingschedule","[Date] =#" &CurrentDateTextbox26 & "#"). What am I doing wrong.
Note: I using a textbox in a form to display the count for the current date.
An alternate method would be to use a "Totals Query" - group by the Date field and Count any field (such as the Date Field). This will accomplish the same thing, and then you can use a DLookup on the query to accomplish the task.