I believe that this is the particular problem area:
CVDate(Int( #" & [Date] & "# ))
I've been messing with this for awhile now and it's just not working properly.
I'm trying to count the number of occurences in the [Status In] field within "Change Dates" where the [Status In] field within "Change dates" is a particular value on the form and the [Date] field within "Change Dates" is the current date.
That was actually my first course of action, but unfortunately it will not work because the [Date] field has the date stored in it as a general date (date and time) format, but I only care about comparing it to the current day. I've used the CVDate(Int([Date])) code elsewhere to parse only the date from the field, but in this instance it does not seem to want to work.