I have a function in my query that calculates the age from the DoB field. On my query I set the criteria
Between [Lower Age] and [Upper Age]
Where lower and upper age are parameters that the user fills in.
In Access 97 this query works fine, however in XP it just produces random results. How can I make this query work in XP.
Between [Lower Age] and [Upper Age]
Where lower and upper age are parameters that the user fills in.
In Access 97 this query works fine, however in XP it just produces random results. How can I make this query work in XP.
