Simple Query Help Needed

[emanuel.levy]

I have a table called tbl_employers. One of the fields is start_date.
I'm trying to make a query that will show all entries where todays date
is 275 days and 305 days after the start date.

Any help would be appreciated

[fredg]

On 3 Nov 2005 08:20:23 -0800, em**********@gm ail.com wrote:

I have a table called tbl_employers. One of the fields is start_date.
I'm trying to make a query that will show all entries where todays date
is 275 days and 305 days after the start date.

Any help would be appreciated

Do you mean between 275 and 305 days?

Select tbl_employers.* From tbl_employers
Where tbl_employers.[Start_Date] Between DateAdd("d",-275,Date()) and
DateAdd("d",-305,Date())

or exactly 275 and exactly 305 days?

Select tbl_employers.* From tbl_employers
Where tbl_employers.[Start_Date] = DateAdd("d",-275,Date()) Or
tbl_employers.[Start_Date] = DateAdd("d",-305,Date())

--
Fred
Please respond only to this newsgroup.
I do not reply to personal e-mail

[emanuel.levy]

Good point. I was planning on having them run the query every day but
that would not cover weekends.

Basically I needed a query that shows what entries are 90 days from
expiration , what ones are 60 days from expiration and what ones are
365 days or more.

The 365 or more was easy it's the other two that are causing problems
for me. I'll try your code samples. I'm using

DateDiff("d",[SHARP Begin Date],Now())
Then using >=365 for the expired ones

=274 for the 90 Day warnings which also bring the ones that are over a year old and I don't want them
and lastly
=305 for the 60 day warnings which is also bringing the ones that expire in 90 days and expired ones.

[fredg]

On 3 Nov 2005 12:47:51 -0800, em**********@gm ail.com wrote:

Good point. I was planning on having them run the query every day but
that would not cover weekends.

Basically I needed a query that shows what entries are 90 days from
expiration , what ones are 60 days from expiration and what ones are
365 days or more.

The 365 or more was easy it's the other two that are causing problems
for me. I'll try your code samples. I'm using

DateDiff("d",[SHARP Begin Date],Now())
Then using >=365 for the expired ones

=274 for the 90 Day warnings which also bring the ones that are over a year old and I don't want them

and lastly

=305 for the 60 day warnings which is also bringing the ones that expire in 90 days and expired ones.

Using Now() in the expression is not a good idea.
Now() includes a time value, therefore the number of records returned
will depend upon the time of day the query is run.
Use Date() instead.

--
Fred
Please respond only to this newsgroup.
I do not reply to personal e-mail

[emanuel.levy]

Thank you for thaty suggestion I'm going to change them to Date.

How would I write the expression 61 to 90 days instead of just 90 days?

[emanuel.levy]

Scratch that. I figured out I can use <= at the end of the expression
to limit what shows and it all looks good.

Thanks for all the help Fred. I hope this helps others as well