Query with Date Prompt or less than

[Lucia Balkamp]

I'm working on a report of pass due items with a date showing when they were due. I would like be able to enter or have today's date automaticly used and have the query only show me all items on the report.

<=#11/18/2010# works
Returns all orders open before 11/18 but this has no prompt

<=["Enter End Date"] does not work
Requests a prompt but returns only one order from 11/17 and does not show older orders

Any help would be really apprecited,
Lucia

 

[boblarson]

Use a Form for input instead of parameter prompts on queries. Parameter prompts are too limited and don't give a good user experience like forms can.

Read this for why not to use them.

Instead you can have a form where the user can either type in the date or select it from a calendar. The criteria in the query can reference the text box:

<= [Forms]![YourFormNameHere]![YourTextBoxNameHere]

 

[Lucia Balkamp]

so there is no code for just entering a simple date?

 

[boblarson]

so there is no code for just entering a simple date?

You can use this:

<= & "#" & ["Enter End Date"] & "#"

But I'm telling you - it is not wise to go with parameter prompts in queries.

 

[Lucia Balkamp]

Don't why I didn't think about it. I just used
<Date()

and it worked

Thank you for your help in getting my brain to work

Lucia