query to return current date or future date

  • Thread starter Thread starter Mark
  • Start date Start date
M

Mark

Hi,

I could use some help. I have a form, which allows users
to select a beginning date and ending date, and when a
user selects the dates a query pulls the records from a
table. The query, "ClassesByDate" has the following field
and criteria:

Field: ClassDate
Criteria: Between [Forms]![formClassCalander]!
[TextBeginningDate] And [Forms]![formClassCalander]!
[TextEndDate]


My question: I would like to also restrict the records
being pulled to only dates that are equal to or less than
the current date. So, someone cannot view classes that
are scheduled prior to the current date. Can I just add
an "and" after the above criteria to accomplish this
task? Something like: and >= date()

Thanks!!!!
 
(Between [Forms]![formClassCalander]![TextBeginningDate]
And [Forms]![formClassCalander]![TextEndDate]) AND <= Date()
 
Back
Top