After Date question

[EVP]

I've searched high and low for the answer to this basic question to no avail, so I apologize if it's somewhere on the forum...

I'm trying to set a parameter query to prompt the user to enter one date, and retrieve all records after that date. (I'm thinking this is a Between and Present criteria, but I can't get it right).

Also, I assume this will transfer once I create a form off of this query?

Any help appreciated.
Thank you.

 

[GumbyD]

In your query in the criteria under the date field type in:

> [Enter Date Value]

That will give all the records where that date is greater than the date entered. You may want to add "Enter Date Value" with a date/time datatype to the query parameters by right clincking in the upper pane and selecting parameters.

GumbyD

 

[EVP]

Thank you,
But this seems to only give me the specific date I enter, not a range of dates from set date to present.
Any thoughts?

 

[GumbyD]

Sure - you can use this:

Between [Enter Date Value] and date()

GumbyD

 

[Mile-O]

Personally, I'd prefer to use a form to determine criteria...never been a fan of using user-typed (oblivious?) parameters into databases...