Access2010 Report Wizard Date Grouping
Posted on 2011-04-26
.mdb file on NAS. Access 2000/2010 mixed multiuser
The best i can tell, VBA format (date) procedure is not working. To keep things simple, i run the query or report wizard and group/summarize on a date field.
If i start a new table with dates, it works. On my existing tables (which are commonly filled with the now() function), it doesn't.
Errors: "...table is in exclusive mode..." and " ..invalid procedure call.."