Can anyone tell me (after looking at the picture) why my if statement isn't working as expected? I'm using: Match: IIf([Quantity]=[Weight],"Match","No Match")
Backstory: I am making a recipe system in which there is 1 table that houses the main recipe and another that house the mixtures that go into it. Say you have 100kg of ingredient 1. If you put 100kg into mixture 3 the query will show that the [Weight] is 100kg and the [Quantity] from table 1 is also 100kg.
I've checked that there are no rounding errors and I'm also getting this with scenario 20 and 20.000 "No Match"
It's boggling me...
Here's another snapshot with 2 different queries using the same formula.
Upon further troubleshooting, I found that retyping the entries on table 1 solved the problem. I'd still like to know what the issue is though.