I am confused on what my Val() expression is doing in my query. Can somebody try to explain this to me please?
My database imports a text file and convernts most of that data into values. I have a query that has two identical expressions of Val([Calls]) where Calls is a text field and they give completely different answers. Why?
Here are a few examples:
Calls Expr9: Val([Calls]) Expr11: Val([Calls])
29 52 29
24 54 24
20 30 20
21 36 21
I would think that both Expr9 and Expr11 would give the same answer. Am I missing something here?
Additionally, I have 5 other Val() expressions based on different text fields that give the answer I was looking for. What happened with Expr9?
My database imports a text file and convernts most of that data into values. I have a query that has two identical expressions of Val([Calls]) where Calls is a text field and they give completely different answers. Why?
Here are a few examples:
Calls Expr9: Val([Calls]) Expr11: Val([Calls])
29 52 29
24 54 24
20 30 20
21 36 21
I would think that both Expr9 and Expr11 would give the same answer. Am I missing something here?
Additionally, I have 5 other Val() expressions based on different text fields that give the answer I was looking for. What happened with Expr9?
