Date Expression

[sadie]

query

I have a database of my cases of kids that we review for services
I have to do a re-review every 30 days for each kid (they are all reviewed on different days)...I have put a field with review date + 30 and it works but I don't know how to call it up in a query

At the beginning of each week, I would like to call up all those due for review that week

I am using access 2000

 

[dcx693]

In your query, create a calculated column that takes the last review date and adds 30 days to it (or use the DateAdd function to just add a month to it if that's better for you).

Use an expression in the Field: line like this: NextReviewDate:[LastReviewDate]+30

 

[sadie]

In your query, create a calculated column that takes the last review date and adds 30 days to it (or use the DateAdd function to just add a month to it if that's better for you).

Use an expression in the Field: line like this: NextReviewDate:[LastReviewDate]+30

Thanks, I'll try it