View Single Post
  #1  
Old May 12th, 2010, 05:19 PM posted to microsoft.public.access.queries
LoriP
external usenet poster
 
Posts: 8
Default Calculated field

I need to calculate many fields based on one start date and I need the
calculations to count by month.
For example first visit is 4/25/2010
The first calculated field must be 5/25/2010 +/- 7 days
This is the first time I've had to do a calculated field where the next
visit must be the exact day of the next month and not just the generic "30
days" Is there an easy way to do this?
Thank you
Lori