date range in a query

  • Thread starter Thread starter Steve
  • Start date Start date
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!
 
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!
 
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!
 
Back
Top