This definitely seems to be the way to fix it. I haven't completely fixed the whole database but tried a smaller scale fix in a blank database and it works great.
THANK YOU!!!! We are undergoing reviews and everyone's performance is in this table!!!
Thank you for the tip! I did indeed find some corrupted data in the table and all the fields in that record show squares instead of text. I tried to delete that record but am coming up with this error:
"The search key was not found in any record"
Click "OK" then...
We have a database that we use to track the work progress for several employees and initially it was discovered that the reports were no longer working for a certain job function. I have isolated the problem to one particular table.
I copied each table one by one into a blank database and each...
How can I calculate the number or working days between two records on a report. I know there is a NETWORKDAYS syntax but I must be formatting it incorrectly.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.