User input date to return query after date


B

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.
 
Ad

Advertisements

G

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.
 
J

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
 
G

Guest

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

Jeff Boyce said:
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

SailorRoy said:
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.
 
G

Guest

[Dates after (enter a date)]
This gave me the results that I needed. Dates after. Thanks for your help.

Roy

Jeff Boyce said:
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

SailorRoy said:
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.
 
J

Jeff Boyce

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

Regards

Jeff Boyce
Microsoft Office/Access MVP

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

Jeff Boyce said:
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

SailorRoy said:
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.
 
Ad

Advertisements

G

Guest

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

Jeff Boyce said:
Sorry, I figured the ">" part was a given.

Regards

Jeff Boyce
Microsoft Office/Access MVP

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

Jeff Boyce said:
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.
 
Ad

Advertisements

Joined
Jun 23, 2007
Messages
61
Reaction score
0
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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top