Variable Date ranges

[Corey_Preman_(Guest)]

I have a query set up to collect data in the range of dates. I want the first date as static while the second is a variable to automatically punch in "todays" date. It will not allow me to do that...__Any ideas?

[kfleming]

Create a calculated field with the date() function.____Then in the query use two clauses to set the range so that __datefield is greater than or equal to first value and datefield is less than or equal to the date()calculated field.____the in the range operator will not accept fieldnames.____Kathleen__R&R Support