Query problems

[cornishteeth]

Can't seem to figure out this. I am trying to query Instructors that transfer in the next 30 days. I created the following:

30DaysPrior: DateAdd("d",-30,[InstructorXferDate])

Perhaps there is an easier way to do this.

Thanks,

Frank

 

[Norie]

Frank

What is the actual problem?

Shouldn't it actually be

30DaysPrior: DateAdd("d",-30, Date)

You're formula would return dates 30 days before InstructorXFerDate.

 

[cornishteeth]

OK. I actually didn't put the problem in there. DateAdd function returns the Instructor Xfer date minus thirty days. This works. The problem is how do I take that date and utilizing a report display the individuals who fall in that category i.e. Instructors leaving in 30 days as of the day when I asked for the report. I hope this makes sense.

Frank

 

[Andrew Fergus]

Hi, is the date-30 calculated in a query or on the report?
Andrew.