Selecting Last ?? Days/Weeks/Months

[waiting12345]

Hi, I'm not too familiar with access dates. I'm programming in ASP and need to say select records from last 30 days. I'd appreciate it if someone could say how I could do this in sql for the table tbdEvents and the field fldDate.

Also how could I extend this to do last so many weeks and months. Appreciate the help. Cheers

 

[Crowley16]

if you're passing an sql directly into access then something like:

... where dateValue > now() - 30

for weeks, just so #weeks * 7
for months, you need to use the dateserial, i.e.
... where dateValue > dateserial(year(now()), month(now()) - #months, day(now()))

you get the picture...

--------------------
Procrastinate Now!

 

[waiting12345]

Genius cheers.