Filter by date in Query

[Stan 2314]

I have a manufacturing schedule I am working on and I would like to make a query that shows only records that have a date of today or later.

[Beetle]

Then create your query and use criteria like;

[YourDateField] >=Date()

It would look like this in the QBE grid;



Now, you can place this criteria directly in your query if you want, but it is usually better to use a form reference because users are normally (or should be) dealing with forms, not directly with queries. So on a form you would have a text box where a user would enter a date value, or the text box could have a default value of Date(), and the query would reference that form control. The criteria in the query would then look like;

>=Forms!YourForm!txtDateBox

[Stan 2314]

Thanks for your responce. I am planning on working off a form but if I want to show today and future dates would it look like >=Date(today) ?

[Stan 2314]

I just tried it the way you said and it does what I want. Thank you so much.