This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(128, 8%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
signed on today and the sum function is not working in all my reports. this is new it has been OK for months
A family of Microsoft relational database management systems designed for ease of use.
Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(89.60000000000001, 51%, 18%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ES%3C/text%3E%3C/svg%3E)
Often when an internal function stops working its because of a Missing Reference. However, there would clearly show a "Missing" identifier in the References list.
Can you show us an Example of the Expression you are using (the ControlSource) that is no longer working.
It is desk top and following your instructions these are the only references to ACCESS and both are checked. don't understand "missing"
Microsoft Access 15.0 Object Library
Microsoft Access 15.0 Database Engine Object Library
As I stated before new to Access I can follow instructions but do not necessarily understand.
thanks
chip
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(256, 41%, 34%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ETV%3C/text%3E%3C/svg%3E)
Is this the web version of Access or the desktop version?
If desktop: you did not answer Scott's question re References. Hit Alt+F11 to show the VBA editor. Then choose Tools > References and check if any of the selected ones are showing as Missing.
It shows blanks in all twenty reports I have created. I am new to ACCESS so my reports are simple table reports created by report wizard. They worked (for 6 months) up until two days ago.
thanks
Did you check to see if there is a problem with references?
What, exactly, does not working mean? Showing an incorrect sum, showing a blank or an #Error or what?