Date issue

[Stoach]

Any resolution dealing with a simple Access database connection? I'm trying to output users whose birthday is within 5 days plus or minus.

[Webtress]

Yes, in a way....I had to have it done for a deadline and was having so many
issues so what I ended up doing was placing the year in a seperate field. This
is not ideal by any means, but it works for my purpose until I have the time to
spend on it. This is the code I am using:

Select name, phone, emp_bd
FROM phone_list
WHERE
emp_bd BETWEEN (Now()-1) AND (Now()+7)
ORDER BY emp_bd

That's it! All you have to do is place the year in a seperate field and adjust
the -+ to your amts.

Hope that helps!