date range in a query

S

Steve

hello i have the following code in a query
[forms]![FORM2]!Between [datein] And [datein2]

i am tryng to perform a date range find using the two fields on form2
[datein] and [datein2] but to no avail any ideas!
 
S

Steve

excellent!

whre can i get a brain like your??
--
Thanks Steve


KARL DEWEY said:
Try this ---
Between [forms]![FORM2]![datein] And [forms]![FORM2]![datein2]

--
KARL DEWEY
Build a little - Test a little


Steve said:
hello i have the following code in a query
[forms]![FORM2]!Between [datein] And [datein2]

i am tryng to perform a date range find using the two fields on form2
[datein] and [datein2] but to no avail any ideas!
Click to expand...
Click to expand...
 
K

KARL DEWEY

A some trial and lots of errors.
--
KARL DEWEY
Build a little - Test a little


Steve said:
excellent!

whre can i get a brain like your??
--
Thanks Steve


KARL DEWEY said:
Try this ---
Between [forms]![FORM2]![datein] And [forms]![FORM2]![datein2]

--
KARL DEWEY
Build a little - Test a little


Steve said:
hello i have the following code in a query
[forms]![FORM2]!Between [datein] And [datein2]

i am tryng to perform a date range find using the two fields on form2
[datein] and [datein2] but to no avail any ideas!
Click to expand...
Click to expand...
Click to expand...
 
Top