Dates

[AccessXP]

I need help with a query showing dates older than 3 weeks.

any help would be appreciated.


Thanks.

 

[dhookom]

Set the criteria under your date field to:
< DateAdd("ww",-3, Date())

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]

 

[AccessXP]

I have a date field that marks the current days date. I need it to find dates that are 21 days or older than the current date.

Sorry for lack of info the first go around.

 

[dhookom]

I am even more confused since I don't understand what you mean by "a date field that marks the current days date".

I also don't know if you tried my solution and if it did or didn't work and why.

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]

 

[AccessXP]

I did try your solution it pulled all records. Thats why I tried to give more information. The date field is todays date when the app is opened.

 

[dhookom]

You must have a date field that is not todays date. Maybe you need to provide some sample records with field names and desired query results.

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]