joet
04-05-2002, 11:31 AM
I am trying to adjust a query to fit the criteria to fall between certain dates, but I am getting dates before the first date; what am I doing wrong?
|
View Full Version : Criteria issue joet 04-05-2002, 11:31 AM I am trying to adjust a query to fit the criteria to fall between certain dates, but I am getting dates before the first date; what am I doing wrong? David R 04-05-2002, 11:43 AM Between [Enter start date] And [Enter end date] Between Forms!Form.DateField1 And Forms!Form.DateField2 (with the form open - need not be bound fields) Between Date() And Date()+30 What are you using as your criteria? David R |