User input date to return query after date

[Bob Quintal]

=?Utf-8?B?U2FpbG9yUm95?= <[email protected]>
wrote in

I have a query that totals and sorts time by the last dates
entered. I want to add a criteria that returns this
information date after by a slected date inputted by user. I
can put >#6/30/2007# into the criteria and it returns the
results that I need but I want this to be entered by the user.
I am lost. Thanks for your help.

Open the query in design view. Open the properties panel. One of
the properties is parameters. Enter a prompt "Enter starting date"
or something similar, set the datatype to date.
In the query's criteria row, under your date field, put > [Enter
Starting Date] now save and test the query.

 

[Guest]

I have a query that totals and sorts time by the last dates entered. I want
to add a criteria that returns this information date after by a slected date
inputted by user. I can put >#6/30/2007# into the criteria and it returns
the results that I need but I want this to be entered by the user. I am
lost. Thanks for your help.

 

[Jeff Boyce]

Try

[Dates after (enter a date)]

in the selection criterion, and enter that same prompt under Queries |
Properties and give it a Date/Time type.

Regards

Jeff Boyce
Micosoft Office/Access MVP

 

[Guest]

I am missing something. It returns entries for that date only not for all
entries after that date.

Try

[Dates after (enter a date)]

in the selection criterion, and enter that same prompt under Queries |
Properties and give it a Date/Time type.

Regards

Jeff Boyce
Micosoft Office/Access MVP

I have a query that totals and sorts time by the last dates entered. I
want
to add a criteria that returns this information date after by a slected
date
inputted by user. I can put >#6/30/2007# into the criteria and it returns
the results that I need but I want this to be entered by the user. I am
lost. Thanks for your help.

 

[Guest]

[Dates after (enter a date)]

This gave me the results that I needed. Dates after. Thanks for your help.

Roy

Try

[Dates after (enter a date)]

in the selection criterion, and enter that same prompt under Queries |
Properties and give it a Date/Time type.

Regards

Jeff Boyce
Micosoft Office/Access MVP

I have a query that totals and sorts time by the last dates entered. I
want
to add a criteria that returns this information date after by a slected
date
inputted by user. I can put >#6/30/2007# into the criteria and it returns
the results that I need but I want this to be entered by the user. I am
lost. Thanks for your help.

 

[Jeff Boyce]

Sorry, I figured the ">" part was a given.

Regards

Jeff Boyce
Microsoft Office/Access MVP

I am missing something. It returns entries for that date only not for all
entries after that date.

Try

[Dates after (enter a date)]

in the selection criterion, and enter that same prompt under Queries |
Properties and give it a Date/Time type.

Regards

Jeff Boyce
Micosoft Office/Access MVP

I have a query that totals and sorts time by the last dates entered. I
want
to add a criteria that returns this information date after by a slected
date
inputted by user. I can put >#6/30/2007# into the criteria and it
returns
the results that I need but I want this to be entered by the user. I
am
lost. Thanks for your help.

 

[Guest]

It should have been but I am new at this and I have been struggling thru.

Sorry, I figured the ">" part was a given.

Regards

Jeff Boyce
Microsoft Office/Access MVP

I am missing something. It returns entries for that date only not for all
entries after that date.

Try

[Dates after (enter a date)]

in the selection criterion, and enter that same prompt under Queries |
Properties and give it a Date/Time type.

Regards

Jeff Boyce
Micosoft Office/Access MVP

I have a query that totals and sorts time by the last dates entered. I
want
to add a criteria that returns this information date after by a slected
date
inputted by user. I can put >#6/30/2007# into the criteria and it
returns
the results that I need but I want this to be entered by the user. I
am
lost. Thanks for your help.

 

[ajetrumpet]

I can put >#6/30/2007# into the criteria and it returns the results that I need but I want this to be entered by the user.

Is the user going to be entering this info. into the query itself? Do you have a criteria form for the user?? If you do, enter the above criteria you mentioned as criteria on a form control.