Data criteria miss match - Microsoft Access Forum


	Back to Access Forum Comments List

Upload Images @Reply Bookmark Link Email Next Unseen

Data criteria miss match

David Nelson

3 years ago

Hello everyone, I have a data mismatch issue after running a query which has a logical expression. The issue shows up when I run the expression to check if a value is greater then the other. However, when I set one of the outcomes as a criteria, I get a data miss match error. I am using my database as front-end for a SharePoint list.

Any ideas as to what might be happening here?

	David Nelson OP @Reply 3 years ago

	David Nelson OP @Reply 3 years ago

	David Nelson OP @Reply 3 years ago

	David Nelson OP @Reply 3 years ago

	John Davy @Reply 3 years ago
Hi David, Have you checked to see if your relationships take into account that LatestSMUQ might not have a record for AssetID? John

	David Nelson OP @Reply 3 years ago
Hi John, I will look through the data tomorrow and let you know what I find.

	Kevin Robertson @Reply 3 years ago
In PMStatus, try wrapping the calculated field in the `CBool` function.

	David Nelson OP @Reply 3 years ago
Hello Kevin, I did wrap it in the CBool function as you mentioned, and got the same result. I looked into what John had mentioned and found 2 empty records. Could this be the problem?

	David Nelson OP @Reply 3 years ago

	David Nelson OP @Reply 3 years ago
Found the issue folks. As John said, there was an error with a record and it was the cause of the problem. Thank you all.

This thread is now CLOSED. If you wish to comment, start a NEW discussion in Access Forum.

Next Unseen

New Feature: Comment Live View