critiera

[Guest]

I have a field called date return in a query. How do I only show the dates
that have already passed? For example.
7/14/06
7/20/06
7/29/06
8/20/06

Only 2 of the dates should show. Once 7/29 has passed then that one will
show.
I tried >[Date Return] I just don't know where to put this. Should I
create a new field in the query?

Thanks
Chey

 

[Guest]

Hi Chey,

Try " < Date() " in the criteria for the [Date Return] field in the query

Hope it helps.
Regards,
Nick

 

[Guest]

I did that but I want it to show after the traveler has returned from there
trip. So that is why I was trying to do it for [Date Return]

Hi Chey,

Try " < Date() " in the criteria for the [Date Return] field in the query

Hope it helps.
Regards,
Nick

I have a field called date return in a query. How do I only show the dates
that have already passed? For example.
7/14/06
7/20/06
7/29/06
8/20/06

Only 2 of the dates should show. Once 7/29 has passed then that one will
show.
I tried >[Date Return] I just don't know where to put this. Should I
create a new field in the query?

Thanks
Chey

 

[John Vinson]

I did that but I want it to show after the traveler has returned from there
trip. So that is why I was trying to do it for [Date Return]

Hi Chey,

Try " < Date() " in the criteria for the [Date Return] field in the query

Ummm... that's what he said to do.

Create a Query based on your Table.
Put < Date() on the Criteria box underneath the [Date Return] field.
It will now show you all completed trips, i.e. those with a DateReturn
value prior to today's date.

Is that not what you're seeing?

John W. Vinson[MVP]