Recent content by Terri Storer

They are all using DCount and are identical to the one provided, except for the last name. I did realize that I had added the new user to the data source and did NOT Reinitialize SQL on that side prior to running this report in Access. That fixed it. HOWEVER, I am very grateful to the...

I have a database linked to a Data Source (a case management system) using ODBC for the purpose of creating reports. Nothing has changed between the data source, ODBC, or MS Access. In one of the reports, I have a footer with Text Boxes to capture a DCount based on staff lastname for the...