Date Query

[Frank]

I have dates in a table that correspond to instructors
dates of transfer. I need to create a query that pulls up
all instructors that are leaving within 30 days. For
example, if I run the query today (December 7th) and an
instructor transfers on January 1st, the query would pull
his name up as a loss. I hope this makes sense

Thanks,
Frank

 

[Guest]

SELECT yourtablename.*
where
datediff("d" , yourtablename.[datefield), now() ) < 30

 

[John Vinson]

I have dates in a table that correspond to instructors
dates of transfer. I need to create a query that pulls up
all instructors that are leaving within 30 days. For
example, if I run the query today (December 7th) and an
instructor transfers on January 1st, the query would pull
his name up as a loss. I hope this makes sense

You should be able to use a criterion on DateOfTransfer of

BETWEEN Date() AND DateAdd("d", 30, Date())


John W. Vinson[MVP]
Join the online Access Chats
Tuesday 11am EDT - Thursday 3:30pm EDT
http://community.compuserve.com/msdevapps