View Single Post
  #1  
Old November 5th, 2012, 07:51 PM
Lee S. Lee S. is offline
Member
 
First recorded activity by OfficeFrustration: Feb 2005
Posts: 9
Default Can I use one prompted date critera to create others?

Hey,

I have had to set up several rather complex queries using nested queries. I am required to enter an initial date, and would like to be able to use that one entry to query the next level of query for a date exactly one month later than the first, and in another case, to have the next level query look back exactly 365 days from the date I originally entered, and in another case merely pass through the original date into another query that is relationally connected to the daughter query of the one where I input the original date.

I tried ([StartDate] - 365), but it didn't like that.

I can manipulate dates in calculated fields rather easilly, but apparently none of this works in the criteria box. So, I currently have several prompts to manually type dates into. This is a major opportunity for errors.

If anybody has any ideas, or a suggestion on a place to look, please let me know.

Thanks,

Lee