I'm confused !
I have a table with two dates (Date1 and Date2). Query has calculated field datediff("d",Date2,Date1). This produces the number of days between the two dates. Now if I enter as criteria for the calculated field >100 I get only those records where the datediff is >100, great, now for the problem, if I enter the criteria for the calculated field as >[Days] thus prompting the user to enter the number of days, entering a value of 100 does not produce the same result, it appears that the calulated field is treated as a text field, meaning 9 is greater than 100.
Can anyone help ??
Dan
I have a table with two dates (Date1 and Date2). Query has calculated field datediff("d",Date2,Date1). This produces the number of days between the two dates. Now if I enter as criteria for the calculated field >100 I get only those records where the datediff is >100, great, now for the problem, if I enter the criteria for the calculated field as >[Days] thus prompting the user to enter the number of days, entering a value of 100 does not produce the same result, it appears that the calulated field is treated as a text field, meaning 9 is greater than 100.
Can anyone help ??
Dan
