Date parameter question

[pat67]

I have a query that pulls data. What I am trying to get it to do is
pull the data greater than a specific date. Is there a way to do it
other than just entering the date in the criteria field in design mode?

 

[John W. Vinson]

I have a query that pulls data. What I am trying to get it to do is
pull the data greater than a specific date. Is there a way to do it
other than just entering the date in the criteria field in design mode?

Sure. How is "a certain date" to be established? Programmatically based on
today's date, by user input, from some other table, ...????

You could for instance use

Date()

to find all future records, or

= DateSerial(Year(Date()), 1, 1)

to find all records during the current year, or

= [Enter start date:]

to prompt the user for a date, or

[Forms]![SomeFormName]![UnboundTextboxName]

to find all records greater than a date value entered on a form.

 

[pat67]

I have a query that pulls data. What I am trying to get it to do is
pull the data greater than a specific date. Is there a way to do it
other than just entering the date in the criteria field in design mode?

Sure. How is "a certain date" to be established? Programmatically based on
today's date, by user input, from some other table, ...????

You could for instance use

Date()

to find all future records, or

= DateSerial(Year(Date()), 1, 1)

to find all records during the current year, or

= [Enter start date:]

to prompt the user for a date, or

[Forms]![SomeFormName]![UnboundTextboxName]

to find all records greater than a date value entered on a form.
--

             John W. Vinson [MVP]
Thanks

=[Enter Date] works perfectly