Select Query is not working

[kashif.special2005]

Hi,

I have a form caled "Form1", in this form I have two text boxes called Text0, and Text2.

I want to create a query that give me a date different of those two text date values

Like:- Text0 value is 01/01/2011
Text2 value is 01/15/2011

I am creating a simple select query like below
Days:DateDiff("d",[forms]![form1].[text0],[forms]![form1].[text2])

It is giving me an error message.

I am not able to understand that what is the problem.

Thanks,
Kashif.

 

[boblarson]

See if this helps:

Days:DateDiff("d",[forms]![form1]![text0],[forms]![form1]![text2])

and if that doesn't then:

Days:DateDiff("d",CDate([forms]![form1]![text0]),CDate([forms]![form1]![text2]))