vXP - query criteria to ask for less than date range

[mastro78]

Is there a way, like using a normal date range set Between [date] And [date], to create a way to ask for less than this [date]? I'm pretty well versed in Access and I've never tried this before. Wondering if I could get some pointers on how to go about this.

Thanks in advance!!

 

[dhookom]

I don't understand your question. Between [date] And [date] is only going to prompt you for one value so it is pointless to use "Between".

IMHO criteria for queries, forms, reports,... should never come from parameter prompts. Always use controls on forms.

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]

 

[mastro78]

What I'm saying I would like a prompt that asks for a date and then the data displayed is less than the date entered.

 

[dhookom]

Set your criteria in your query to something like:

<=Forms!frmDateCriteria!txtEndDate

Again, IMHO prompts aren't acceptable user interface.

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]