R
Rover
I'm running A2K under WinXP Pro.
I have a query that computes age: Age: Now()-[MinOfAppDAte] - works
fine. If I put in the criteria field >99, that works fine.
The Problem: if I put >[Enter age greater than] in the criteria and
enter 99, I only get those ages that have "99" in the age. I understand
(I think) the problem - Its looking at the entered field as a string and
processing it as "Like 99*".
How do I make my entered data look like a number?
TIA
Jim
I have a query that computes age: Age: Now()-[MinOfAppDAte] - works
fine. If I put in the criteria field >99, that works fine.
The Problem: if I put >[Enter age greater than] in the criteria and
enter 99, I only get those ages that have "99" in the age. I understand
(I think) the problem - Its looking at the entered field as a string and
processing it as "Like 99*".
How do I make my entered data look like a number?
TIA
Jim