i have table i want display date month only automaticly

M

mah

how can make the rules about show date before 7 month

like when i use any date i want automaticly back show 7 month

here date for today 11/12/2004
i want here show 7 month back
1- 31May2004
2-30June2004
3-31July2004
4- 31August2004
5-30September2004
6-31October2004
7-30November2004
 
S

Steve Schapel

Mah,

Does this do what you want?...

In the ccriteria of your date field in a query, put like this...
 
Top