I have query that has 4 fields, borrower, estimated closing, review file, loan status.
(fields) Borrower Estimated Closing Review file Loan Status
(data type) text date date text
(sample) jim smith, 05/10/1971, blank, approved


What I was wondering is if ther is a way to auto-populate the review file date field with a date subtracting 60 days from the estimated closing date.

hope I explained clearly, let me know if you need any other information.

Oh yea, this query will be put in a report to be generated weekly, if there is a way to do it in reports.

Thanks for the help.

Jonathan

access uses days as a base for date calculation so you can make your estimate an unbound text field populated with [Estimated Closing]-60

thanks, sounds great.

Could i get one more favor, im a newbie.

Could explain how i would do this.

thanks jonathan

when you make your query
right click on a blank field block
select build
type in
[Estimated Closing]-60
access will automatically assign a variable name to it which you can rename to Due_Date or something like that if you want

Thank you Thank you and Thank you again.

If I can be so bold and ask one more related question, any way to remove weekend and holiday days.

I want to say thank you again, your help is greatly apprecialted

Jonathan'

here is a bit of reading on working with holidays and weekends
http://www.access-programmers.co.uk/forums/showthread.php?t=87474&highlight=weekend