By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
426,248 Members | 1,979 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 426,248 IT Pros & Developers. It's quick & easy.

Need Help--Reports over specified period of time

P: n/a
I need help trying to extract by query records that are 30 days or
more past the current date.

I am trying to track loss reporting and want to be able to identify
losses that are still open after 30 days or more from the current
date.

I am a beginner user of MS Access so please address your response to
my level.
Nov 12 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
As the criteria for the date field, write:
<= Date() - 30

--
Fred

Please reply only to this newsgroup.
I do not reply to personal e-mail.
"NWLPM" <nw***@yahoo.com> wrote in message
news:c0**************************@posting.google.c om...
I need help trying to extract by query records that are 30 days or
more past the current date.

I am trying to track loss reporting and want to be able to identify
losses that are still open after 30 days or more from the current
date.

I am a beginner user of MS Access so please address your response to
my level.

Nov 12 '05 #2

P: n/a
Open the source query of your report and add

<Now()-30

to the criteria under the past current date field

"NWLPM" <nw***@yahoo.com> wrote in message
news:c0**************************@posting.google.c om...
I need help trying to extract by query records that are 30 days or
more past the current date.

I am trying to track loss reporting and want to be able to identify
losses that are still open after 30 days or more from the current
date.

I am a beginner user of MS Access so please address your response to
my level.

Nov 12 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.